How to generate surrogate key without using surrogate key stage?
Answer Posted / sudhir
Surrogatekey is nothing but a unique number to identify the
record in datamart. So just use a counter in StageVariable
of Transformer. Keep incrementing the counter by one for
every new inserts. This would form a surrogatekey.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to clean the datastage repository?
Have you used Unstructured data?
What are the different common services in datastage?
How to perform incremental load in datastage?
How a server job can be converted to a parallel job?
How do you reject records in a transformer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How many areas for files does datastage have?
What are the functionalities of link partitioner?
Define Merge?
What can we do with datastage director?
What are the main features of datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
What is ibm datastage flow designer?
Can you explain link buffering?