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
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
How do y read Sequential file from job control?
Can you implement SCD2 using join, transformer and funnel stage?
Can we use target hash file as a lookup ?
What is difference between server jobs & parallel jobs?
What is the project in datastage?
how many rows sorted in sort stage by default in server jobs
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is the difference between datastage and informatica?
How you can fix the truncated data error in datastage?
Demonstrate experience in maintaining quality process standards?
Differentiate between Join, Merge and Lookup stage?
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
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
