Hi All,

Can you please help me in this scenario. I have one source table S1 which has following data

a1  10
a1  10
a1  10
a2  20
a2  20
a3  30

There are 2 target tables T1 and T2. I would be needing all the unique records in T1 and one instance of the duplicate row in other even if it has more than 2 rows in the i/p database.

o/p should be :
T1
a1 10
a2 20
a3 30

T2
a1 10
a2 20

Please let me know.

Thanks,
Praveen

Thanks Whoever,

But I wanted to know, who to solve this in informatica. It might be the case that the source and table be a flat file.

Thanks,
Praveen

Thanks Allegra,

I got it.

Thanks,
Praveen