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
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.
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
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
