Generating Surrogate key value

maffan76 · Post by **maffan76** » Tue Sep 13, 2005 8:00 am

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.

singhald · Post by **singhald** » Tue Sep 13, 2005 8:20 am

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