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
Have you have ever worked in unix environment and why it is useful in datastage?
Explain entity, attribute and relationship in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Explain the situation where you have applied SCD in your project?
What is the difference between validated and compiled in the datastage?
What is the method of removing duplicates, without the remove duplicate stage?
how to abort the job its matain duplicates?
Define Data Stage?
What is the difference between Datastage 7.5 and 7.0?
Can you define merge?
Define oconv () and iconv () functions in datastage?
Is possible to create skid in dim,fact tables?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the differentiate between data file and descriptor file?
