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 / suresh
surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are stage variables, derivations and constants?
What are the functionalities of link partitioner?
What is the difference between operational data stage (ods) and data warehouse?
project Steps,hits, Project level HArd things,Solved methods?
Difference between data warehousing and olap?
Explain the situation where you have applied SCD in your project?
How a source file is populated?
what is the use of surogate key in datastage
How to perform incremental load in datastage?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the enhancements made in datastage 7.5 compare with 7.0?
Enlist various types of routines in datastage.
Different ways a project can be moved to production ?...example ….export-import and Version control.
Can you explain players in datastage?
CHANGE CAPTURE