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

How one source columns or rows to be loaded in to two different tables?

1130

---

What are the types of containers?

1235

---

How many types of sorting methods are available in datastage?

1073

---

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

1112

---

What is the difference between passive stage and active stage?

1538

---

What are routines in datastage?

1329

---

What are the different options associated with dsjob command?

1436

---

Define oconv () and iconv () functions in datastage?

1416

---

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?

2211

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2242

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188

---

What is a ds designer?

1070

---

how to abort the job its matain duplicates?

2574

---

What are the job parameters?

1221

---

What is usage analysis in datastage?

1306

---