5 / 94
How do you remove Duplicate records in Informatica? And how many ways are there to do it?
IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING
FIRST WAY IS
USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.
BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.
SECOND WAY:
IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.
THIRD WAY:
Asked In ::
ROJA
2 Aug, 2022 12:07 PM
IN INFORMATICA TO REMOVE DUPLICATE RECORDS BY USING
FIRST WAY IS
USING SOURCE QUALIFIER TRANSFORMATION CLICK ON PROPERTIES AND SELECT DISTINCT PROPERTY THEN YOU WILL REMOVE DUPLICATE RECORDS.
BY USING SOURCE QUALIFIER YOU CAN OVERRIDE THE SQL QUERY YOU CAN REMOVE DUPLICATE RECORDS BUT IT IS WORKING ONLY FOR DATA BASE SOURCE NOT WORKING FOR FLAT FILES.
SECOND WAY:
IN SORTER TRANSFORMATION ALSO YOU CAN CLICK ON PROPERTIES TAB SELECT DISTINCT PROPERTY THIS SCENARIO ALSO WORKING TO REMOVE DUPLICATE RECORDS.
THIRD WAY: