Archives: Informatica

Informatica Interview Questions – Part – 5

1. Why we use stored procedure transformation? For populating and maintaining data bases. 2. What is aggregate cache in aggregator transformation? The aggregator stores data in the aggregate cache until it completes aggregate calculations. When we run a session that uses an aggregator transformation, the informatica server creates an index and data caches in the • Read More »


Informatica Interview Question Banks

Informatica Interview Questions – Part – 1 Informatica Interview Questions – Part – 2 Informatica Interview Questions – Part – 3 Informatica Interview Questions – Part – 4 Informatica Interview Questions – Part – 5


Informatica Interview Questions – Part – 4

1. While importing the relational source definition from database, what are the metadata of source you import? Source name Database location Column names Data types Key constraints 2. What is the use of transformation? Transformation is being done on the repository that is being stored in the object and it allows the synchronization to be • Read More »


Informatica Interview Questions – Part – 3

1. In a joiner transformation, you should specify the source with fewer rows as the master source. Why? Joiner transformation compares each row of the master source against the detail source. The fewer unique rows in the master, the fewer iterations of the join comparison occur, which speeds the join process. 2. What is Lookup • Read More »


Informatica Interview Questions – Part – 2

1. What is meant by direct and indirect loading options in sessions? Direct loading can be used to single transformation where as indirect transformation can be used to multiple transformations or files. In the direct we can perform recovery process but in indirect we cant do it . 2. What is predefined event? It is • Read More »


Informatica Interview Questions – Part – 1

1. Difference between static and dynamic cache and explain with one example? Answer : Static – once the data is cached , it will not change, example unconnected lookup uses static cache. Dynamic – the cache is updated as to reflect the update in the table (or source) for which it is reffering to.(ex. Connected • Read More »