Interested to Buy Any Domain ? << Click Here >> for more details...
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
- 5 Answers
- 10309 Views
- SLK Software, I also Faced
- E-Mail Answers
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
Define Merge?
What is the difference between orabulk and bcp stages?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Difference between data warehousing and olap?
Terminate Activity
Define Data Stage?
Differentiate between hash file and sequential file?
Is the value of staging variable stored temporarily or permanently?
What can we do with datastage director?
What is orabulk stage?
sed,awk,head
What is the use of hoursfromtime() function in transformer stage in datastage?
Is it possible to query a hash file?
What are the various kinds of containers available in datastage?
What are the primary usages of datastage tool?
