informatica mapping to count the no.of employees in each organisation

Question

can anyone tell me how to create mapping for the following scenario:

Source:                 Target:
emp_id  org             EMP_COUNT  ORG
1         x                2         X
2         Y                2         Y
3         X                1         z
4         Y
5         Z

Answer 1

Use an aggregator transformation with ORG as group by port. For EMP_COUNT, create an output port in the aggregator with the expression: COUNT(emp_id).