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

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

Question Posted / kautilya

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

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / kiran

There is a surrogate key option in transformer.

Is This Answer Correct ?

9 Yes

1 No

Post New Answer

More Data Stage Interview Questions

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

0 Answers

How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?

1 Answers IBM,

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers TCS,

how can we create tables in datastage?

1 Answers

how can i abort the job if i get more than 100 errors in job log?

6 Answers Accenture,

Is possible to create skid in dim,fact tables?

0 Answers NTT Data,

what is flow of project?

0 Answers HSBC, IBM,

With out using Funnel Stage, how to populate the data from different sources to single target