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
- 10331 Views
- SLK Software, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh
surrogate key is alternate to primary key,it allows duplicates also,while maintain the hystorical data we use surrogate key
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / prabhu rathnam
Surrogate key is used to generate sequence of number from 1 to n. It increment by 1 continously and sequencly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / karan am
surrogate key is alternate to primary key, in order to maintain historical data.
The key source can be a state file or a database sequence. If you are using a database sequence, the sequence must be created by the Surrogate Key stage. You cannot use a sequence previously created outside of DataStage.
| Is This Answer Correct ? | 0 Yes | 0 No |
sed,awk,head
What is the Difference Between DataStage 7.5 version and 8.1 Version?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
I have 100 records how can I load at a time from the single time
State the difference between an operational datastage and a data warehouse?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
Can you explain engine tier in information server?
What r the existing server jobs in parallalism?
what are the different type of errors in datastage?
Teradata 
