How to refresh a lookup table after every iteration
Posted: Wed Mar 05, 2008 3:31 am
Hello all,
In a Datastage Enterprise Edition job, is it possible to refresh a lookup to reflect inserts done to the lookup table within the same job?
My job writes records to a table X, It is capable of insert new records, insert new versions and update old versions of existing records. The lookup to identify existing records and new versions is done to the same table X. The problem arises because the input data may have several versions of the same record inside.
Thank you in advance
In a Datastage Enterprise Edition job, is it possible to refresh a lookup to reflect inserts done to the lookup table within the same job?
My job writes records to a table X, It is capable of insert new records, insert new versions and update old versions of existing records. The lookup to identify existing records and new versions is done to the same table X. The problem arises because the input data may have several versions of the same record inside.
Thank you in advance