top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to delete duplicate record in Informatica?

+1 vote
363 views
How to delete duplicate record in Informatica?
posted Jun 10, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

if the source is database means we can delete the duplicate records by enabling the option select distinct in source qualifier t/r properties or by writing the following query in source qualifier filter

delete from emp where rowid not in (select min(rowid) from emp group by empno);

if the source is flat file means by enabling the option distinct in sorter t/r we can delete the duplicate records

answer Jun 10, 2015 by Manikandan J
Similar Questions
+2 votes

How can we delete duplicate rows from source database table using informatica. This has to be done without using any other table. Means source and target is same table in Oracle database.

0 votes

Suppose if we have duplicate records in a table temp_n. Now I want to pass unique values to t1 and duplicate values to t2 in single mapping? How can we achieve?

...