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

Whats difference betweeen operational data stage (ods) and data warehouse?

1102

---

Difference between data warehousing and olap?

1073

---

project Steps,hits, Project level HArd things,Solved methods?

2107

---

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

1122

---

What are the different plug-ins stages used in your projects?

1062

---

Can you explain kafka connector?

1290

---

What are the functionalities of link partitioner?

1005

---

What are the types of views in datastage director?

1757

---

why do u need the IOS upgradation in a FC switch

2269

---

What are sequencers?

1093

---

What is datastage engine?

1166

---

State the difference between an operational datastage and a data warehouse?

1121

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4022

---

Give an idea of system variables.

1007

---

Could anyone give brief explanation bout datastage admin

2345

---