Answer / vamsi

use copy stage , drag for multiple out puts

Answer / raman

Use the same job for loading by parameterizing the file
name the table name.

Answer / geetha

Use transformer stage and modulus function. Lets say we have 4 target tables and set constraint to each target links as below.

Link1--> mod(@INROWNUM,4)=0
Link2--> mod(@INROWNUM,4)=1
Link3--> mod(@INROWNUM,4)=2
Link4--> mod(@INROWNUM,4)=3

we can also use filter stage and where clause to split the records

Answer / srikanth

very good answer

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

what is initial load and incremental load

3 Answers   ADP,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,

---

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

To see hidden files in LINIX?

0 Answers   CTS,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

how many write modes are there in ds

2 Answers   IBM,

---

Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?

1 Answers   TCS,

---

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,

---