How To Delete Duplicate Row Using Informatica?

1.	How To Delete Duplicate Row Using Informatica?
Answer» Assuming that the source system is a Relational Database, to ELIMINATE duplicate records, we can CHECK the DISTINCT option of the Source Qualifier of the source table and LOAD the target accordingly. Assuming that the source system is a Relational Database, to eliminate duplicate records, we can check the Distinct option of the Source Qualifier of the source table and load the target accordingly.

Answer»

Assuming that the source system is a Relational Database, to ELIMINATE duplicate records, we can CHECK the DISTINCT option of the Source Qualifier of the source table and LOAD the target accordingly.

Assuming that the source system is a Relational Database, to eliminate duplicate records, we can check the Distinct option of the Source Qualifier of the source table and load the target accordingly.

Discussion

No Comment Found

Related InterviewSolutions

When We Create A Target As Flat File And Source As Oracle. How Can I Specify First Rows As Column Names In Flat Files?
What Is Meant By Direct And Indirect Loading Options In Sessions?
What Is Difference Between Informatica 7.1 And Abinitio?
How To Join Two Tables Without Using The Joiner Transformation?
Difference Between Static And Dynamic Cache And Explain With One Example?
How The Informatica Server Sorts The String Values In Ranktransformation?
What Is Data Merging, Data Cleansing, Sampling?
What Are The Unsupported Repository Objects For A Mapplet?
Discuss Which Is Better Among Incremental Load, Normal Load And Bulk Load.
What Is Update Strategy Transformation ?

How To Delete Duplicate Row Using Informatica?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment