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

Answers were Sorted based on User's Feedback



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

Answer / venkatesh

the flow will be like this

source---->transformer----->t1
--------->t2
----------->t3
in transformer create a stage variable which holds the value
of mod(id,3) for instance it will be like this

mod(ds.link2.inputrow id,3) |stgvar
______________________________________________|__________
|

use this stage variable in constraint as

ds.link4 stgvar=1
ds.link5 stgvar=2
ds.link6 stgvar=0

connect the input to the output in transformer


u will get the desired output

Is This Answer Correct ?    3 Yes 0 No

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

Answer / srikanth

We can use round robin partition method.

Is This Answer Correct ?    4 Yes 2 No

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

Answer / joe

we can use a transformer with constraint mod(@INROWNUM,3)=2
for trgt1,, =1 for Trgt2, =3 for Trgt3

Is This Answer Correct ?    4 Yes 3 No

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

Answer / mcssrinivas009

we can use random partion concept

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  


What is the flow of loading data into fact & dimensional tables?

0 Answers  


what is a message handler

3 Answers   IBM,


Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,






Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  


explain unit testing,systemtesting,integrated testing

1 Answers   CSC,


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,


What are routines in datastage?

0 Answers  


Thanks to all people who are posting their comments...

1 Answers   CTS,


Could anyone give brief explanation bout datastage admin

0 Answers  


is it possible to access the same job by two users at a time in DataStage?

2 Answers   IBM,


Categories