What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
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 |
Is there any possibility to generate alphanumeric surrogate key?
Can you explain engine tier in information server?
What are transforms and what is the differenece between routines and transforms?
1.what is materialized data? 2.how to view the materialized data?
What modeling tool do you use?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
How can we improve performance of data stage jobs?
Unix command to view the data in a dataset
Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
Define data aggregation?