Posted On: Jan 09, 2021
distinct property(keyword) is used to eliminate duplicate rows in Informatica from a database and a flat-file.
We can eliminate duplicate rows from the flat-file by using group by function in an aggregator or in source qualifier in database.
You can select distinct all or by using sorter transformation in flat-file.
You can remove duplicates values in Informatica from DB as follows:
You can use the Distinct option of the Source Qualifier in the source table and load the target accordingly.
You can remove duplicates values in Informatica from Flat-file as follows:
When the source system is a Flat File distinct option is disabled in the source qualifier. You may use a Sorter Transformation and check the Distinct option. Then all the columns will the selected as keys, in ascending order by default.
Never Miss an Articles from us.