Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
what is flow of project?
How can you write parallel routines in datastage PX?
Terminate Activity
What are the different options associated with dsjob command?
How do you import and export the datastage jobs?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Which algorithm you used for your hashfile?
How do you schedule or monitoring the job?
Where do you see different stages in the designer?
What is the different type of jobs in datastage?
Where the datastage stored his repository?
How a routine is called in datastage job?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the functionalities of link partitioner and link collector?
