Informatica Interview Question Bank Informatica Repository / Repository Manager Q. What type of repositories can be created using Informatica Repository Manager? Q. What is a code page? Q. Which all databases PowerCenter Server on Windows can connect to? Q. Which all databases PowerCenter Server on UNIX can connect to? Informatica Designer Q. How to execute PL/SQL script from Informatica mapping? Q. How can you define a transformation? What are different types of transformations available in Informatica? Q. What is a source qualifier? What is meant by Query Override? Q. What is aggregator transformation? Q. What is Incremental Aggregation? Q. How Union Transformation is used? Q. Can two flat files be joined with Joiner Transformation? Q. What is a look up transformation? Q. Can a lookup be done on Flat Files? Q. What are Connected and Unconnected Lookups? Q. What is a mapplet? Q. What does reusable transformation mean? Q. What is update strategy and what are the options for update strategy?