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
- 10322 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 |
where we use config file as parameter ?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
What is a quality stage?
how can u connect the client system directly at any time?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
Describe stream connector?
Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?
What is the use of surrogate key stage?
What is process model?
Explain the ChangeApply stage?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
Teradata 
