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
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is usage analysis in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
options available in sequence job to run,validate?
Define repository tables in datastage?
Can you highlight the main features of ibm infosphere information server?
how to add a new records into source?
How to implement complex jobs in data stage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between passive stage and active stage?
How many Key we can define in remove duplicate stage?
Explain usage analysis in datastage?
Highlight the main features of datastage?
Why we use surrogate key?
How many types of hash files are there?