Load Distinct and Duplicate values to different targets

[tanya123]

I have a scenario in which the source consists of 2 cols
10 A
10 A
20 C
30 D
40 E
20 C
and there are 2 targets one to load distinct values and another one to load duplicate values.
T1 T2
10 A 10 A
20 C 20 C
30 D
40 E

How to load

[ramud2]

Use an Aggregator Transformation and in the transformation, using count function, try to find out if there are duplicates or not. After aggregator, use a router and route the values based on the count. Hope this helps