If you want the SCD stage to generate new surrogate keys by using a key s

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING
SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT
EVEN IF THE JOB IS COMPILED REPEATEDELY?

Question Posted / kiran

4 Answers
18055 Views
L&T, I also Faced
E-Mail Answers

Answer Posted / kiran

If you want the SCD stage to generate new surrogate keys by
using a key source that you created with a Surrogate Key
Generator stage, you must use the NextSurrogateKey function
to derive the Surrogate Key column.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is datastage engine?

1176

Difference between server jobs & parallel jobs?

1072

Notification Activity

1398

What is a merge in datastage?

1263

What is active and passive stage?

1411

How do you schedule or monitoring the job?

1204

How can you write parallel routines in datastage PX?

1012

Can you define merge?

1117

Differentiate between odbc and drs stage?

1048

Define Merge?

1317

which r the connectors used in san?

2182

What is a ds designer?

1068

What is ds designer?

1097

What is quality stage?

985

What are the partitioning techniques available in link partitioner?

2272