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

Have you used Unstructured data?

1327

---

Explain Quality stage?

1162

---

Distinguish between informatica & datastage. Which one would you choose and why?

1012

---

root tree will find which is server job and which is parallel job?

1976

---

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

1278

---

Could anyone give brief explanation bout datastage admin

2362

---

how to delete one row in target dataset

3127

---

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)

926

---

What are the differences between datastage and informatica?

1182

---

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

1135

---

What are the functionalities of link partitioner and link collector?

1013

---

EXPLAIN SCD

1414

---

What is the use of datastage director?

1021

---

Why do you need stage variables?

1187

---

What is the difference between Datastage 7.5 and 7.0?

1104

---