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 / prabhu rathnam
Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How and where you used hash file?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Terminate Activity
Explain datastage architecture?
project Steps,hits, Project level HArd things,Solved methods?
What are the different kinds of views available in a datastage director?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the difference between passive stage and active stage?
What is the difference between server job and parallel jobs?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Why we use surrogate key?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are constraints and derivations?
What is the difference between in process and inter process?
What are the steps required to kill the job in Datastage?