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

Answer / srikanth

We can use round robin partition method.

Answer / joe

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

Answer / mcssrinivas009

we can use random partion concept

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

What is the different type of jobs in datastage?

0 Answers  

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,

---

i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,

---

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

0 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---