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

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5120

---

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

1026

---

How one source columns or rows to be loaded in to two different tables?

1130

---

Can you explain kafka connector?

1311

---

What are sequencers?

1115

---

Does datastage support slowly changing dimensions ?

1104

---

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

1235

---

How to reverse the string using unix?

3507

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2061

---

Give an idea of system variables.

1032

---

Have you used Unstructured data?

1319

---

What is the roundrobin collector?

1097

---

Why do we use link partitioner and link collector in datastage?

1136

---

What all are the different way to run a job?

1093

---

Can you implement SCD2 using join, transformer and funnel stage?

1557

---