topic Re: [resolved] Delta load / Oracle in Talend Studio

[resolved] Delta load / Oracle

Anonymous — Sat, 16 Nov 2024 12:56:50 GMT

Hi all,
hopefully to get an answer to my question, I'll try to describe my problem below:
I need to load the delta from a table to another table, quit simple... I thought...
All components, source and target, are tOracleInput and tOracleOutput. The source and target sample-data looks like this:
Source
--------
ID(sequence) somedata
1 data1
2 data2
3 data3
4 data4
5 data5

Target
--------
ID somedata talendPID
1 data1 asdf
2 data2 asdf
3 data3 qwer
4 data4 qwer

As you maybe assume, I need to load the source data entry 5 without overwriting the other lines in the target table. Using the standard component-options like 'action on data' (update) didn't work for me using a flow like this:
Source main......
\
tMap (left join) ---> tOracleOutput Target
Target lookup..../
A second problem could be the sequence in tMap, where I create the ID... just because I wasn't able to find a function for incrementing an ID for a table.

Version:
Talend Integration Suite - PE 4.1.2

Thank you for your posts!
Best regards

Re: [resolved] Delta load / Oracle

Anonymous — Tue, 03 May 2011 12:19:44 GMT

Any ideas?

Re: [resolved] Delta load / Oracle

Anonymous — Tue, 03 May 2011 15:32:27 GMT

Issue resolved!
Just in case you got the same issue, contact me via mail.

Re: [resolved] Delta load / Oracle

Anonymous — Wed, 04 May 2011 16:55:03 GMT

Thanks for the feedback tos_user.
Best,
Pcoffre.

Re: [resolved] Delta load / Oracle

_AnonymousUser — Fri, 13 May 2011 22:43:07 GMT

This forum is for sharing. please put the brief about the solution that you have. thanks in advance.

Re: [resolved] Delta load / Oracle

Anonymous — Mon, 16 May 2011 08:27:30 GMT

Hi again,
just to complete this topic, attached you'll find a screenshot using a simple way of loading delta records in case you don't have any timestamps in your source.
Using tMap, create a left outer join to lookup your target, then just check if the target field is empty (null). And there you go!
Rgds
Ben

Re: [resolved] Delta load / Oracle

Anonymous — Thu, 19 May 2011 10:07:51 GMT

sorry
but if your target has CUST_ID as an *incremental* integer - could you not find the max() and then filter your source using that?

Re: [resolved] Delta load / Oracle

Anonymous — Tue, 29 Sep 2015 11:13:57 GMT

Hi tis_user,
I have the same problem like you mentioned. But I can't see the attachment picture.
Can you give me some clue??