Answer Posted / 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

What are stage variables?

1256

---

How you can fix the truncated data error in datastage?

1887

---

What is usage analysis in datastage?

1363

---

How we can covert server job to a parallel job?

1260

---

What all are the different way to run a job?

1139

---

How can we improve the performance in datastage?

1147

---

Have you have ever worked in unix environment and why it is useful in datastage?

1190

---

Can you highlight the main features of ibm infosphere information server?

1125

---

What is ibm datastage?

1024

---

How many types of hash files are there?

1234

---

What is a ds designer?

1114

---

What are the job parameters?

1269

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1462

---

How to perform incremental load in datastage?

1265

---

What are the some differences between 7.x and 8.x version of datastage?

1308

---