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 perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

Name the different types of Lookups in Datastage?

0 Answers  

---

How To find the location of APT_confid file

2 Answers   CTS,

---

explain about citrix scheduling tool in datastage

0 Answers   HSBC,

---

Explain usage analysis in datastage?

0 Answers  

---

What are the main features of datastage?

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?

1 Answers   TCS,

---

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

---

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

---

What could be a data source system?

0 Answers  

---

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

---