Informatica INTERVIEW QUESTION & ANSWERS
| 86. |
What is router transformation? |
| |
Router transformation is an Active and Connected transformation. A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions. |
| 87. |
What is lookup transformation? |
| |
Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables. |
| |
Posted by Anish Ranjan. (July 31, 2014) |
| |
In informatica 9.1 it is an active transformation. |
| 88. |
What is source qualifier transformation? |
| |
Source Qualifier transformation is an Active and Connected transformation. When adding a relational or a flat file source definition to a mapping, it is must to connect it to a Source Qualifier transformation. The Source Qualifier performs the various tasks such as overriding default SQL query, filtering records; join data from two or more tables etc. |
| 89. |
what is update strategy transformation ? |
| |
Update strategy transformation is an active and connected transformation. It is used to update data in target table, either to maintain history of data or recent changes. |
| 90. |
What is the functionality of Repository manager? |
| |
Repository manager is used to navigate through multiple folders and perform the basic repository tasks. |
