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

how to sort two columns in single job in datastage.

0 Answers   TCS,

---

What are the steps needed to create a simple basic datastage job?

0 Answers  

---

where the log files or tables can store in DS?

2 Answers   IBM,

---

What is ibm datastage?

0 Answers  

---

What are constraints and derivations?

0 Answers  

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

On which interface you will be working as a developer?

0 Answers  

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 Answers  

---

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

why dataset ?

2 Answers  

---