Dynamic lookup in DS
Posted: Mon May 31, 2010 12:05 pm
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!
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!