Informatica interview questions and answers part 7

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

45. How does the recovery mode work in informatica?
 Ans - In case of load failure an entry is made in OPB_SERV_ENTRY(?) table from where the extent of loading can be determined.

46.How do you measure session performance?
Ans -This can be done by check marking Collect performance Data check box.

47.Can we use Reusable Sequence Generator transformation in Mapplet?
Ans - No this cannot be done.

48.What is the difference between Filter transformation and Router transformation?
Ans - Filter transformation drops the data that do not meet the condition while latter captures the data even though the condition is not met and saves it in Default output group.

49.What is SQL override?
Ans - SQL override means overriding SQL in source qualifier or lookup for additional logic.

50.What are the types of data movement in Informatica server?
Ans - The two types of modes in Informatica are s below -
         1.Ascii mode    2. Unicode mode

51.How can PL/SQL script can be executed from Informatica mapping?
Ans - Stored Procedure transformation can be used to execute PL/SQL Scripts from informatica mapping.

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