In transformer Properties, there is a tab called “Surrogate Key”. Here

how can we create a Sorrogate key in transformer stage? I
want it in parallel mode

Question Posted / varma

2 Answers
11570 Views
Syntel, I also Faced
E-Mail Answers

Answer Posted / varma

In transformer Properties, there is a tab called “Surrogate Key”. Here we can define it.
We can select from
a. Flat file : State file which holds the SK values and generates SK values.
b. DB Sequence: Database sequence object to use to generate the SK values.

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

1897

Different ways a project can be moved to production ?...example â€¦.export-import and Version control.

1932

How and where you used hash file?

655

What are the different layers in the information server architecture?

641

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3309

Difference between sequential file and data set?

641

What is a ds designer?

640

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3377

What is quality stage?

570

Can we use target hash file as a lookup ?

2814

Can you explain repository tables in datastage?

899

How to manage date conversion in Datastage?

638

What are the repository tables in datastage?

819

Can you explain kafka connector?

775

What is the difference between datastage and informatica?

609