Answer Posted / vinod upputuri

Appreciate your Answer but it was wrong..because if you are using Agregator stage it will give only unique records with record count. so how can u print all the duplicate records.


in the above senario:

input to agregator stage: 251,251,456,456,951,985
i used count rows.
so, the o/p is 251,2
456,2
951,1
985,1
if U use the Filter stage then what is the output:
O/P1:
251
456

O/P2:
951
985

Unfortunately this is not the answer we are required...

This is not as simple as U think...i implemented it before posting!!!!!

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2005

---

What is the differentiate between data file and descriptor file?

1305

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2925

---

in oracle target stage when we use load option and when we use upsert option?

2203

---

What are the stages in datastage?

1028

---

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

1224

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2387

---

What is the project in datastage?

1047

---

What is a quality stage in datastage tool?

1023

---

What is the difference between orabulk and bcp stages?

967

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

887

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2209

---

what is the use of materialized view?

1487

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1094

---

Explain usage analysis in datastage?

1095

---