count record based on key field without droping nonkey field

[singhald]

Hi

I need to count source records using key fields and attched this count to all record in output.

I want to keep all source records and fields in target with record count based on key field.

Exmple:
Source data
Key Col2 Col3
1 A X
1 B Y
2 C Z
3 D S
3 D Y

output

Key Col2 Col3 Count
1 A X 2
1 B Y 2
2 C Z 1
3 D S 2
3 D Y 2



right now i am doing this by using copy stage, aggregator and join stage.

do we have any best solution to achive this logic.

Thanks in advance

[ray.wurlod]

Does your "fork join" design work? If so, that's the design to use.

[singhald]

Thanks Ray,

fork join design is working. i just wanted to know, is this design optmized to achive the outcome ?

[ray.wurlod]

What alternative is there?

If your answer to that question is "none", then my answer to your question is "yes".