Page 1 of 1
Creating a key using database sequence in the transformer
Posted: Sun Nov 13, 2011 7:27 am
by SUMAN CHILUVURI
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?
Posted: Sun Nov 13, 2011 8:17 am
by pandeesh
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.
Posted: Sun Nov 13, 2011 8:42 am
by chulett
Read the documentation on the NextSurrogateKey() transformer function.
Posted: Sun Nov 13, 2011 9:03 am
by pandeesh
Refer page no 195 in the parallel job developer guide