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

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? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

0 Answers IBM,

What are the stages in datastage?

0 Answers

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers IBM,

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers TCS,

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers Amdocs, TCS,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers IBM,

how many types of remove the duplicate records?

3 Answers Caterpillar,

Why we use surrogate key?

0 Answers

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers

how to call routines in stages?

3 Answers ME,

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers Wipro,

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers CTS, IBM,

For more Data Stage Interview Questions Click Here