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
- 10304 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
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
what is use of SDR function?
How do you reject records in a transformer?
What are the different kinds of views available in a datastage director?
which r the connectors used in san?
What are the types of containers?
What is datastage?
What is ibm datastage flow designer?
What are the differences between datastage and informatica?
How do y read Sequential file from job control?
Explain ibm infosphere information server and highlight its main features?
Explain the situation where you have applied SCD in your project?
Whats difference betweeen operational data stage (ods) and data warehouse?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the areas of application?
