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
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
If you want to use a same piece of code in different jobs, how will you achieve this?
If you want to use the same piece of code in different jobs, how will you achieve it?
How do you run datastage job from the command line?
What is the difference between passive stage and active stage?
What is a quality stage in datastage tool?
how to add a new records into source?
Can you explain engine tier in information server?
Enlist various types of routines in datastage.
why do u need the IOS upgradation in a FC switch
How to implement complex jobs in data stage?
State the difference between an operational datastage and a data warehouse?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How to manage date conversion in Datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?