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.

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

How to create a doccument in datastage?

1 Answers   Cap Gemini,

---

how to find out number of records imported into source file?

1 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

What is difference between 8.1 , 8.5 and 9.1 ?

1 Answers   IBM,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

0 Answers   CGI,

---

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

---