Informatica Interview Questions for Developer role

1) What are the different components of Informatica mapping ?

Informatica mapping defines the data flow from source to target. Source definition, target definition, transformations and links are the components of a mapping.


2) What is a mapplet?



Mapplet is a reusable object created using mapplet designer. It contains transformation logic that can be reused across multiple mappings. Mapplets can have multiple source definitions , transformations and outputs. 

3) What is the difference between mapping parameter and mapping variable ?

Mapping parameter is a constant value that need to be defined before the start of a session. The mapping parameter value cannot be changed during the session run.

Mapping variable value can be changed during the session using SETVARIABLE function. The integration service store the mapping variable value to the repository after successful completion of a session.


4) What are the different type of joins that can be used in a joiner transformation ?

Normal Join : Keeps rows only if both master and detail source match ( equi join ).
Master Outer Join : All rows from detail and only matching rows from master.
Detail Outer Join : All rows from master and only matching rows from detail.
Full Outer Join : Keep all rows from both master and detail.