mapping to load all unique products in one table & duplicate rows in another table in informatica
Input data
A
B
C
C
B
D
B
Design a mapping to load all unique products in one table and the duplicate rows in another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C