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!!!!!

explain about citrix scheduling tool in datastage

2445

---

What is the difference between odbc and drs stage?

1087

---

What are the benefits of datastage?

1234

---

How many types of views are there in a datastage director?

1280

---

how to add a new records into source?

1994

---

What are orabulk and bcp stages?

1119

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2437

---

What are transforms and what is the differenece between routines and transforms?

1055

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1734

---

What all the types of jobs you developed?

1175

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2202

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3163

---

What are data elements?

1165

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1383

---

what are the devoleper roles in real time? plz tell i am new to datastage....

2153

---