20 informatica interview questions and answers

1.What are the different types of repositories created using Informatica? 2.What is the use of code page? - Informatica 3.What is the way to execute PL/SQL script using Informatica mapping? 4.What is the use of transformation? - Informatica 5.What are different types of transformations available in Informatica? 6.What is the use of source qualifier? - Informatica 7.What is meant by Query Override? - Informatica 8.What is the function of aggregator transformation? - Informatica 9.What is the use of Incremental Aggregation? - Informatica 10.What is the function of Union Transformation? - Informatica 11.What is the function of look up transformation? - Informatica 12.What is the difference between a connected look up and unconnected lookup? - Informatica 13.What is main use of mapplet? - Informatica 14.What does reusable transformation mean? - Informatica 15.What are the different options available for update strategy? - Informatica 16.What is the difference between Router and Filter? - Informatica 17.What are the conditions needed to improve the performance of Informatica Aggregator Transformation? - Informatica 18.What are the different lookup cache(s)? - Informatica 19.Write the program through which the records can be updated? - Informatica 20.What is the difference between STOP and ABORT options in Workflow Monitor? - Informatica Write your comment - Share Knowledge and Experience Discussion Board Regarding the blog feedack Awesome blog thanks for sharing. Johnson 03-1-2017 02:25 AM Feedback Hi, Nice collections ..very usefull for freshers and can you please share some more questions in deeper analysis Shiva 07-8-2014 05:38 AM informatica These questions would be very helpfull to the students,even who are coming into this technology.We hope that get some questions . Thank you so much for sharing your knowledge. Tks, Veeru veeru 06-28-2013 07:16 AM