What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
Answer Posted / karan am
surrogate key is alternate to primary key, in order to maintain historical data.
The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are data elements?
What is the different type of jobs in datastage?
What is the purpose of pivot stage?
Terminate Activity
Define ds designer?
How one source columns or rows to be loaded in to two different tables?
sed,awk,head
What is staging variable?
How to implement complex jobs in data stage?
What are the functionalities of link collector?
What is the difference between the local container and shared container?
Highlight the main features of datastage?
Difference between data warehousing and olap?
What is the difference between Datastage 7.5 and 7.0?
CHANGE CAPTURE