Question: What are the different ways to remove duplicates in informatica power center?

If source is database (DBMS), then select distinct in source Qualifier or same can be achieved by using SQL Override.

Use Aggregator transformation and select all the group by ports.

Use Sorter transformation and select the Sort Distinct Property to achieve the distinct Values.

Question: What do you mean by target load order?

Target load order in the Informatica server provides the flexibility that data inserted into target table in predefined sequence. Target load order can also be set if anyone want to maintain referential integrity while inserting, updating, and deleting data from table that has primary and foreign key constrains.

Question: What is joiner transformation in Informatica Powercenter?

1. Joiner Transformation is a connected and active transformation.

2. Joiner transformation is used to join the source data from two heterogeneous sources residing in different locations or file systems.

3. Joiner Transformation can also join data from same sources.

4. Number of joiners = Number of source -1

The joiner Transformation supports following types of Joins.

1. Normal Join (In this join only the matching record of both the tables return from both the sources as output)

Normal Join is equivalent to EQUI JOIN.

2. Master Outer Join (In this join all the records from the details source table and only matching records of master table returns as output)

Master Outer Join is equivalent to EQUI JOIN with remaining rows from detail table/source.

3. Detail Outer Join (In this join only matching records returns from the details source table and all the records from master source table are returned as output)

Detail Outer Join is equivalent to EQUI JOIN with remaining rows from master table/source.

4. Full Outer Join (In this join all the records from master and details tables are returned as output)

Full Outer Join is equivalent to EQUI JOIN with Remaining rows form both tables/sources.

Question: What are the differences between mapplet and mapping?

Question: What are the properties of source qualifier transformation?

SQL Query: To write a query in according the requirement which replaces the default query.

User-Defined Join: Condition is to be used to join multiple sources.

Source Filter: This property of source qualifier transformation filter condition services applies when row is querying.

Select Distinct: This property is used to filter duplicate data.

Pre-SQL: Pre-session SQL commands runs before the source database been read before integration services of informatica.

Post-SQL: Post-session SQL commands runs after the Integration Service writes to the target.

Number of Sorted Ports: It is used for sorting the source data.

Question: What is Sorter Transformation in Informatica Powercenter?

Sorter Transformation is active and connected Transformation which is used to sort data in Ascending or Descending order which is based on key. Key may be single or multiple.

It is also used to eliminate duplicate from by choosing distinct option in sorter transformation.

Due to distinct option, it is called as active transformation.

Sorter Transformation is equivalent to “ORDER BY” clause in SQL.

Sorter Transformation is also used for case-sensitive sorting of data.

Sorter Transformation increases the performance of Informatica.

Click here, for more Informatica MDM interview Question and Answer