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
Define Routines and their types?
How many types of hash files are there?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What are datastage sequences?
What is the precedence of stage variables,derivations, and constraints?
What is a merge in datastage?
What are the various kinds of the hash file?
What are the important features of datastage?
how to abort the job its matain duplicates?
Can you explain players in datastage?
What is the difference between in process and inter process?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the types of containers?
Describe routines in datastage? Enlist various types of routines.