1.

How to remove duplicate rows in Informatica?

Answer»

If you want to delete DUPLICATE records then you can use this query.Example

Select rowNumber FROM tableName
WHERE rowNumber  
       IN (SELECT rowNumber
             FROM (SELECT rowNumber  
                        , ROWNUMBER() OVER(PARTITION BY C1,C2,C3) dup
                     FROM tableName)
            WHERE dup> 1 )


Discussion

No Comment Found

Related InterviewSolutions