Informatica MCQ Quiz

  1. What Is Informatica.
  2. Which is the reusable component in Informatica?
  3. ETL Stands for -
  4. Which one is not correct about filter transformation?
  5. Which of the following server governs the implementation of various processes among the factors of server’s database repository.
  6. Which of the following transformation is used to combine data from different sources?
  7. What is the full form of OLAP?
  8. Which of the following transformation is used to handle cobol sources?
  9. Which of the following window in desginer is used to access the repositories?
  10. Which of the following option is need to be checked for creating shortcuts for folders?
  11. Which of the following session property enabled when update strategy is used in a mapping?
  12. Which of the following tool is used for users, user groups and priviledges?
  13. The repository server create and update the repository tables through -
  14. Which of the following transformation is used to convert the rows in to columns?
Informatica MCQ

Take Informatica Quiz To test your Knowledge 

Below are few Informatica MCQ test that checks your basic knowledge of Informatica. This Informatica Test contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You can see the correct answer by clicking view answer link.

Also, Read Best Informatica interview questions.

  • Reporting
  • Modeling
  • ETL
  • None
View Answer
  • Workflow
  • Mapplet
  • Session
  • Mapping
View Answer
  • Extraction,transformation and loading
  • Extract transactions and load
  • Enable transactions and load
  • All of the mentioned
View Answer
  • Act like 'Case' in pl/sql
  • Act as a 'where' condition
  • Can't passes multiple conditions
  • None of the above
View Answer
  • Lookup transformation
  • Joiner transformation
  • Union Transformation
  • Expression transformation
View Answer
  • On-Line Analytical Processing
  • On-Line Analysis Processing
  • On-Line Access Processing
  • On-Line Application processing
View Answer
  • Filter Transformation
  • Source Qualifier
  • Normalizer Transformation
  • Expression Transformation
View Answer
  • Navigation
  • Workspace
  • Mapping desginer
  • None of the above
View Answer
  • Shortcuts
  • Create Shortcuts
  • Allow shortcut
  • None of the above
View Answer
  • Repository Manager
  • Workflow Manager
  • Designer
  • None of the above
View Answer
  • Native drivers
  • LAN Drivers
  • PSTN Lines
  • Repository agent process
View Answer
  • Filter Transformation
  • Source Qualifier
  • Normalizer Transformation
  • Router Transformation
View Answer
  • Source Qualifier
  • Router Transformation
  • Filter Transformation
  • None of the above
View Answer
  • Flatfiles
  • Cobol and XML sources
  • Homogeneous & Heterogeneous
  • All of the above
View Answer
  • PowerCenter Clients
  • PowerCenter Service
  • Repository Service
  • All of the above
View Answer
  • Global Repositories
  • Local Repositories
  • National Repositories
  • Both A & B
View Answer