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
- 10087 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 job control?
How do you import and export data into datastage?
Can you define merge?
table actions available in oracle connector?
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...
Distinguish between informatica & datastage. Which one would you choose and why?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Can you explain tagbatch restructure operator?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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
Define repository tables 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...
What is the difference between datastage and informatica?
What is the use of datastage designer?
