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 ?    3 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

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,


if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  


Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please

1 Answers   Systime,


Enlist various types of routines in datastage.

0 Answers  


Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,






How a source file is populated?

0 Answers  


How can we do null handling in sequential files

3 Answers   Reliance,


Can you explain engine tier in information server?

0 Answers  


if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????

3 Answers  


1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  


how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,






Categories