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
- 10480 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
whom do you report?
What is the difference between an operational datastage and a data warehouse?
sed,awk,head
table actions available in oracle connector?
How do you remove duplicate values in datastage?
What are the partitioning techniques available in link partitioner?
What are stage variables?
Define ds designer?
What are orabulk and bcp stages?
Define data aggregation?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How to implement complex jobs in data stage?
What all the types of jobs you developed?
What are the primary usages of datastage tool?
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
