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
Which warehouse using in your datawarehouse
What are routines in datastage? Enlist various types of routines.
Can you explain kafka connector?
What are sequencers?
What is difference between join, merge and lookup stage?
What is a merge in datastage?
what is repositery?
What all are the different way to run a job?
Can you explain link buffering?
Explain usage analysis in datastage?
What can we do with datastage director?
What are the different type of jobs in datastage?
what is the use of skid in reporting?
Define meta stage?
what is 'reconsideration error' and how can i respond to this error and how to debug this