How do remove duplicates values in informatica from DB and Flat file?

Alastair Xerxes
Alastair Xerxes

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Cognizant Informatica interview questions

    What is Star schema in informatica?

    Star Schema in a data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. As its structure resembles a star so it is known as a star schema....

    Cognizant Informatica interview questions

    What is snow flake schema ?

    In the data warehouse, Snowflake Schema is a logical arrangement of tables in a multidimensional database...

    Cognizant Informatica interview questions

    What are different types of SCD?

    The different types of SCD are as follows: Type 0 – Fixed Dimension. No changes allowed, dimension never changes. Type 1 – No History. Update record directly, there is no record of histo...