Hi,
i have 2 tables and i have one intermediate table containing the incremental data and the other one is the main table. i want to assign the incremental value to all the rows in intermediate table starting from the maximum value of the target table.
whats the possible approaches and pros and cons?
Thanks in advance.
Generating Surrogate key value
Moderators: chulett, rschirm, roy
Generating Surrogate key value
Regards,
Affan
"Questioning is Half Knowledge"
Affan
"Questioning is Half Knowledge"
hi
using the SCD job u can create Surrogate key value to coloumn.
in this job u have to use a hash file as lookup and same file u will use for update the data.
u look up in to hash file based on incomming data from main file or load.
just create a stage varibale to generate surrogate key based on id coloumn.
singhal
using the SCD job u can create Surrogate key value to coloumn.
in this job u have to use a hash file as lookup and same file u will use for update the data.
u look up in to hash file based on incomming data from main file or load.
just create a stage varibale to generate surrogate key based on id coloumn.
singhal