Informatica MCQ

Informatica MCQ

  • Admin
  • 18th Jun, 2022

Informatica MCQ Questions

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.

Informatica MCQ Quiz

1) What Is Informatica.

  • A. Reporting
  • B.Modeling
  • C.ETL
  • D.None

2) Which is the reusable component in Informatica?

  • A. Workflow
  • B.Mapplet
  • C.Session
  • D.Mapping

3) ETL Stands for -

  • A. Extraction,transformation and loading
  • B.Extract transactions and load
  • C.Enable transactions and load
  • D.All of the mentioned

4) Which one is not correct about filter transformation?

  • A. Act like 'Case' in pl/sql
  • B.Act as a 'where' condition
  • C.Can't passes multiple conditions
  • D.None of the above

5) Which of the following server governs the implementation of various processes among the factors of server’s database repository.

  • A. Temp server
  • B.Repository server
  • C.Domain server
  • D.Powerhouse server
Download Free : Informatica MCQ PDF

6) Which of the following transformation is used to combine data from different sources?

  • A. Lookup transformation
  • B.Joiner transformation
  • C.Union Transformation
  • D.Expression transformation

7) What is the full form of OLAP?

  • A. On-Line Analytical Processing
  • B.On-Line Analysis Processing
  • C.On-Line Access Processing
  • D.On-Line Application processing

8) Which of the following transformation is used to handle cobol sources?

  • A. Filter Transformation
  • B.Source Qualifier
  • C.Normalizer Transformation
  • D.Expression Transformation

9) Which of the following window in desginer is used to access the repositories?

  • A. Navigation
  • B.Workspace
  • C.Mapping desginer
  • D.None of the above

10) Which of the following option is need to be checked for creating shortcuts for folders?

  • A. Shortcuts
  • B.Create Shortcuts
  • C.Allow shortcut
  • D.None of the above

11) Which of the following session property enabled when update strategy is used in a mapping?

  • C.Data Driven

12) Which of the following tool is used for users, user groups and priviledges?

  • A. Repository Manager
  • B.Workflow Manager
  • C.Designer
  • D.None of the above

13) The repository server create and update the repository tables through -

  • A. Native drivers
  • B.LAN Drivers
  • C.PSTN Lines
  • D.Repository agent process

14) Which of the following transformation is used to convert the rows in to columns?

  • A. Filter Transformation
  • B.Source Qualifier
  • C.Normalizer Transformation
  • D.Router Transformation

15) Which of the following Transformation is used to load the rejected records?

  • A. Source Qualifier
  • B.Router Transformation
  • C.Filter Transformation
  • D.None of the above

16) Which of the following types of sources are available in informatica?

  • A. Flatfiles
  • B.Cobol and XML sources
  • C.Homogeneous & Heterogeneous
  • D.All of the above

17) Which of the following component of informatica is used to see the performance of the workflow while running?

  • A. Mapping Designer
  • B.Workflow Monitor
  • C.Worklet Designer
  • D.Workflow Manager

18) Can INFORMATICA objects be written in XML format?

  • A. Yes
  • B.No

19) What is the different components of PowerCenter?

  • A. PowerCenter Clients
  • B.PowerCenter Service
  • C.Repository Service
  • D.All of the above

20) What are the two types of Repositories in INFORMATICA?

  • A. Global Repositories
  • B.Local Repositories
  • C.National Repositories
  • D.Both A & B

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

Docker MCQ
Maven MCQ
Robotics MCQ