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 u connect the client system directly at any time?

1 Answers   IBM,

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

Define Data Stage?

0 Answers  

---

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

6 Answers   TCS,

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  

---

I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time

7 Answers   TCS,

---

What are the third party tools you used in your project?

1 Answers   IBM,

---

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AND WHAT STAGES ARE THERE?WHAT LOGIC?

1 Answers   TCS,

---