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 materialized view used datastage?

1 Answers   HSBC,

---

whom do you report?

0 Answers   NTT Data,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

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

0 Answers  

---

i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,

---

what is flow of project?

0 Answers   HSBC, IBM,

---

Which algorithm you used for your hashfile?

0 Answers  

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

Differentiate between datastage and informatica?

0 Answers  

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

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

0 Answers  

---