count number of deptno in a emp table?
- 2 Answers
- 4466 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 2 Yes | 0 No |
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 This Answer Correct ? | 1 Yes | 0 No |
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
What is ibm datastage flow designer?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
can we see the data in fixed width file? how can u change the datatype of fixed width files?
How can you write parallel routines in datastage PX?
What is the purpose of pivot stage and types of containers in datastage
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
Have you used Unstructured data?
What are stage variables, derivations and constants?
What are the types of jobs we have in datastage?
can any one tell me how to install datastage 8.1 in windows xp with wizard
what is advantages of snowflake when it is used?
Teradata 
