Best Informatica Interview Questions & Answers

Deleting duplicate row using Informatica Q1. Suppose we have Duplicate records in Source System and we want to load only the unique records in the Target System eliminating the duplicate rows. What will be the approach?
Ans.
Let us assume that the source system is a Relational Database . The source table is having duplicate rows. Now to eliminate duplicate records, we can check the Distinct option of the Source Qualifier of the source table and load the target accordingly.



Source Qualifier Transformation DISTINCT clause

But what if the source is a flat file? How can we remove the duplicates from flat file source?To know the answer of this question and similar high frequency Informatica questions, please continue to,
Best Informatica Interview Questions (Page 2) >>
You must Register Or Log In first to access the FULL article. Registration is FREE and takes less than 1 minute to get started!Sample Questions from Next Page
How to delete duplicate row for FLAT FILE sources?
How to Load Multiple Target Tables Based on Conditions?
How to Load Multiple Flat Files using one mapping
What happens to a mapping if we alter the datatypes?
Describe the situations where we will use the Source Filter, Select Distinct and Number Of Sorted Ports properties of Source Qualifier transformation.
What is the difference between Source Qualifier transformations Source Filter to Filter transformation?
State the limitations where we cannot use Joiner in the mapping pipeline.
How does Joiner transformation treat NULL value matching?
What are the changes we observe when we promote a non resuable Sequence Generator to a resuable one?