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