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
Differentiate between odbc and drs stage?
How many types of stage?
How many types of views are there in a datastage director?
What are the benefits of datastage?
What are the different type of jobs in datastage?
What is a merge?
What is oci?
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 are the types of containers and how to create them?
What is a quality stage in datastage tool?
What is the difference between odbc and drs stage?
What are some prerequisites for datastage?
What is meta stage?
Define project in datastage?
What are the steps required to kill the job in Datastage?