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



What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Genera..

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

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Genera..

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

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Genera..

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

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Genera..

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

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Genera..

Answer / mohanasam

pls example

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Data Stage Interview Questions

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,


what is the use of surogate key in datastage

0 Answers   TCS,


What are iconv and oconv?

0 Answers  


What is staging variable?

0 Answers  


How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,






what is set mapping in datastage??

2 Answers   ADP,


how many stages are there in Datastage... Please clarify mee??

3 Answers  


Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?

1 Answers   HCL,


Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  


What is a ds designer?

0 Answers  


What are the job parameters?

0 Answers  


how to change left and right links in join stage?

4 Answers   Cap Gemini, IBM,


Categories