Creating a key using database sequence in the transformer

SUMAN CHILUVURI · Post by **SUMAN CHILUVURI** » Sun Nov 13, 2011 7:27 am

I need to use the database sequence to generate keys in a transformer stage and send it to target database stage DB2.

Can any one help me how to achieve this?

pandeesh · Post by **pandeesh** » Sun Nov 13, 2011 8:17 am

Do you mean for each input record,the database sequence.nextval should be processed?
i guess the efficient way is using surrogate key generator stAge.

chulett · Post by **chulett** » Sun Nov 13, 2011 8:42 am

Read the documentation on the NextSurrogateKey() transformer function.

pandeesh · Post by **pandeesh** » Sun Nov 13, 2011 9:03 am

Refer page no 195 in the parallel job developer guide