Informatica interview questions and answers part 4

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]
 
24. In how many ways can you add ports?
Ans - Ports can be added using 2 ways

• From other transformation
• Click on add port button

25.What are the two modes of data movement in Informatica Server?
Ans - There are 2 modes of data movement in informatica server 1. Normal Mode 2. Bulk Mode

26. What is Normal mode of data movement in Informatica Server?

Ans -  Normal Mode is a mode in which for every record a separate DML statement is prepared and executed.

27.  What is Normal mode of data movement in Informatica Server?

Ans - Bulk Mode s a mode in which for multiple records DML statement is prepared and executed thus improves performance.

28.What is the use of target designer?

Ans - target designer is used to create Target Definition.

29.What are the different types of Lookup Cache?
Ans - Following are the different types of lookup cache

• Recache from database
• Static cache
• Shared cache
• Dynamic cache
• Persistent cache

30.What are the two types of processes that run the session?
Ans - The two types of processes that run the session are
         1.Load Manager
         2. Data Transformation Manager processes

Part1[1-7]  Part2[8-14]  Part3[15-23]  Part4[24-30]  Part5[31-37]  Part6[38-44]
Part7[45-51]