Answer Posted / venugopal

Take source in the sequential file and take two copy stages
and map the columns to two copy stages and use funnel stage
to funnel the data from two copy stages and o/p into the
file now you can see the o/p is your requirement....

Hope this will help you...

What all the types of jobs you developed?

1177

---

AGGREGATOR default datatype

1457

---

how to delete one row in target dataset

3113

---

What are routines in datastage? Enlist various types of routines.

1099

---

What all are the different way to run a job?

1090

---

What are the types of hashed files in data stage

1106

---

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

1019

---

What is the difference between informatica and datastage?

1218

---

Define meta stage?

1200

---

What is the difference between orabulk and bcp stages?

1023

---

What is ibm datastage?

967

---

how to add a new records into source?

1996

---

How to reverse the string using SQL?

1520

---

Differentiate between operational datastage (ods) and data warehouse?

1174

---

What is the flow of loading data into fact & dimensional tables?

1059

---