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
12694 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

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers IBM,

Explain connectivity between datastage with datasources?

0 Answers

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers Cap Gemini,

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers CGI,

What are the important features of datastage?

0 Answers

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers TCS,

what is the difference between the join and look up explin me one exmple

3 Answers

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers

deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers IBM, TCS,

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers CTS,

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers

For more Data Stage Interview Questions Click Here