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

How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?

3 Answers   Caterpillar,

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

0 Answers  

---

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers   TCS,

---

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,

---

Describe routines in datastage? Enlist various types of routines.

0 Answers  

---

what are the types of nodes

4 Answers   HCL, TCS,

---

what about data stage requirement

1 Answers  

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  

---

What is ds designer?

0 Answers  

---