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
Printable View
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
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