How to generate surrogate key without using surrogate key stage?

Answer Posted / venkatesh.m

by using the transformer we can do it.To generate seqnum
there is a formula by using the system variables
ie
[@partation num + (@inrow num -1) * @num partation

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1148


What is usage analysis in datastage?

1053


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1990


options available in sequence job to run,validate?

1068


Define repository tables in datastage?

910


Can you highlight the main features of ibm infosphere information server?

894


how to add a new records into source?

1737


How to implement complex jobs in data stage?

867


Explain the datastage parallel extender (px) or enterprise edition (ee)?

987


What is the difference between passive stage and active stage?

1092


How many Key we can define in remove duplicate stage?

1048


Explain usage analysis in datastage?

887


Highlight the main features of datastage?

835


Why we use surrogate key?

935


How many types of hash files are there?

853