Hi,
How can dynamic lookup be implemented in Datastage in a single job? I mean if there are 2 records in the source file/dataset which is looked up on a table and one inserted to table (same table as it was looked up on) as it is new (or the first one) and will the second record be updated to the table (in case columns other than key/lookup columns are different)...
I guess this will be possible by Insert else update option.. is this correct?
Please let me know, thanks!
Dynamic lookup in DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
The easiest way to do this is to remove duplicates in your processing stream so you only add one row to the lookup table. Use the Remove Duplicates stage, sort by a key field or a date field and take the first or last duplicate.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn