Answer / naganji mandru

Using aggrgator one way,Another way write query from database stage like

Select deptno,count(*) as c from emp group by deptno

Answer / nish

use aggregator stage: Group by Deptno.
In the calculation field: select RecCount

this will create a new column with count of deptno. Make sure to map to the output stage.

Hope this helps your poorly framed question.

How can we achive parallelism

1 Answers   CTS,

---

what is the function in Transformer stage can act as Rank function in Oracle

1 Answers   Reliance,

---

Can we use target hash file as a lookup ?

1 Answers  

---

what is sparse lookup?

7 Answers   IBM,

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1 Answers  

---

how can we create rank using datastage?what is the meaning of rank?

1 Answers   IBM,

---

what is use of SDR function?

1 Answers   CGI,

---

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

---

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

---

What are the stages in datastage?

1 Answers  

---

What is the difference between Link collector and Funnel Stages?

1 Answers  

---

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,

---