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?

1117

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

921

---

What are the types of views in datastage director?

1776

---

How to perform incremental load in datastage?

1204

---

What is size of a transaction and an array means in a datastage?

1315

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

Give an idea of system variables.

1037

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

808

---

What is the differentiate between data file and descriptor file?

1364

---

whom do you report?

1935

---

What is orabulk stage?

1048

---

Differentiate between validated and Compiled in the Datastage?

1285

---

How a routine is called in datastage job?

1118

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1384

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2264

---