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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are orabulk and bcp stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
Define oconv () and iconv () functions in datastage?
What is apt_config in datastage?
What is the differentiate between data file and descriptor file?
How to Remove Duplicate using SQL?
how do u catch bad rows from OCI stage? And what CLI stands for?
Differentiate between validated and Compiled in the Datastage?
How can you write parallel routines in datastage PX?
Define Data Stage?
Differentiate between operational datastage (ods) and data warehouse?
What are the steps required to kill the job in Datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Lookup constraints