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
- 8450 Views
- SLK Software, I also Faced
- E-Mail Answers
Answer Posted / siva katta
"Surrogate key" which is system generated unique numeric values.
uses:
---------
when implimenting the SCD2 $SCD3. because these scd's are needs to maintain the historical information. so there is no way to maintain the historical information with Primary key constraint,so we are gonna generate the Surrogate key for identifying the records need to take the insert or update action.
Note :
------
Surrogate key we can use for many purpose and so many cases but the above usage is one of these.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Define project in datastage?
What are the areas of application?
EXPLAIN SCD
What are iconv and oconv?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Describe the main features of datastage?
Differentiate between odbc and drs stage?
How many types of stage?
What are the functionalities of link collector?
How rejected rows are managed in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are datastage sequences?
Explain ibm infosphere information server and highlight its main features?
What is quality stage?
