Informatica MCQ Questions

Informatica MCQ Questions | Freshers & Experienced

  • Sharad Jaiswal
  • 12th Feb, 2021

We have listed below the best Informatica MCQ Questions for your basic knowledge of Informatica. This Informatica MCQ Test contains 25 multiple Choice Questions. You have to select the right answer to every question.

Informatica MCQ Questions

1) Which one is not correct about filter transformation?

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

2) Reusable component in Informatica are:

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

3) OLAP stands for______

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

4) Two types of Repositories in Informatica are:

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

5) What ETL Stands for_____

  • A. Extract, Transform, Load
  • B.Extreme, Transform, Load
  • C.Enable, Transactions, Load
  • D.None of the above

6) Which of the following is not an ETL tool?

  • A. Datastage
  • B.Informatica
  • C.Visual studio
  • D.DT/studio.

7) A partition executes in a________.

  • A. single reader, or writer thread
  • B.multiple reader, transformation, or writer thread
  • C.single reader, transformation, or writer thread
  • D.single reader, multiple transformation, or multiple writer thread

8) Parameters are created in which tool?

  • A. Designer
  • B.Workflow monitor
  • C.Repository manager
  • D.Admin console

9) Which of the following cashes used in informatica?

  • A. Static
  • B.Dynamic
  • C.dynamic,static
  • D.Dynamic,Static,persistent

10) Which schema is a good alternative to the star schema.

  • A. Star schema.
  • B.Fact constellation.
  • C.Snowflake schema.
  • D.Star-snowflake schema.

11) Type of relationship in star schema is______

  • A. one-to-one.
  • B.one-to-many.
  • C.many-to-one.
  • D.many-to-many.

12) Flatfile cannot be used for

  • A. Aggregator
  • B.Source
  • C.Lookup
  • D.Target

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

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

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

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

15) Can INFORMATICA objects be written in XML format?

  • A. TRUE
  • B.FALSE

16) Different Components of PowerCenter?

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

17) Which task is used anywhere in the workflow to run the shell commands?

  • A. Session Task
  • B.email Task
  • C.Command Task
  • D.Standalone Command Task

18) Which process is used for online analytical processing?

  • A. Data
  • B.Database
  • C.Data mart
  • D.Data warehouse

19) Which Component gets metadata from Repository?

  • A. Informatica Server
  • B.Informatica Designer
  • C.Informatica Workflow Designer
  • D.Informatica Repository service

20) Which one is not an active transformation?

  • A. Store Procedure
  • B.Sequence generator
  • C.Sql
  • D.Normalizer

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
React JS MCQ
01st
Feb
Angular Js MCQ
01st
Feb
Angular 2 MCQ
01st
Feb
JSON MCQ
01st
Feb
PHP MCQ