Answer Posted / subhash

1. SRC---->TFM---->TGT
in the TFM, by using Looping we, can do this.
@ITERATION<=5

2.SRC---->COPY===>(5copies/links)==>FUNNEL---TGT

take 5 output links from copy stage, pass those to Funnel
then you will get the desired output.

3. SRC--->TGT
run the job 5 time in 'APPEND' mode

What are some prerequisites for datastage?

1170

---

How do you reject records in a transformer?

1176

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2285

---

What is the process of killing a job in datastage?

1067

---

How do you import and export the datastage jobs?

1209

---

What are some different alternative commands associated with "dsjob"?

1213

---

What is a datastage job?

1055

---

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

1171

---

What are the functionalities of link partitioner and link collector?

1061

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1561

---

How do u convert the columns to rows in datastage?

1245

---

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

1183

---

Define orabulk and bcp stages?

1178

---

How will you move hashed file from one location to another location?

2214

---

Have you used Unstructured data?

1371

---