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
- 10477 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
how do u catch bad rows from OCI stage? And what CLI stands for?
How a source file is populated?
What are the different types of lookups in datastage?
How many areas for files does datastage have?
What is the difference between datastage and datastage tx?
Name the third party tools that can be used in datastage?
Why fact table is in normal form?
Where do you see different stages in the designer?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Define Routines and their types?
Can you explain kafka connector?
Define meta stage?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is size of a transaction and an array means in a datastage?
What is the importance of the exception activity in datastage?
