Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10259 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
what is the use of surogate key in datastage
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
On which Dimension Table you implemented SCD Type in your Project
If you want to use a same piece of code in different jobs, how will you achieve this?
State the difference between an operational datastage and a data warehouse?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to write server Routine coding?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Describe link sort?
How do you generate sequence number in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How a server job can be converted to a parallel job?
Lookup constraints
How do you import and export data into datastage?
