Informatica MCQ Questions

Informatica MCQ Questions | Freshers & Experienced

  • Sharad Jaiswal
  • 19th Jun, 2021

We have listed below the best Informatica MCQ Questions for your basic knowledge of Informatica. This Informatica MCQ Test contains 25+ Informatica Multiple Choice Questions. You have to select the right answer to every question to check your final preparation for Informatica MCQ Interview, Exam, or Placement Drives.

Practice Best 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

21) Informatica is a software development company founded in ...............

  • A. 1990
  • B.1991
  • C.1992
  • D.1993

22) Which of the following Function(s) cannot be used in Expression Widget?

  • A. AVG
  • B.TRIM
  • C.LTRIM
  • D.RTRIM

23) ............... test is used in an online transactional processing environment.

  • A. ACID
  • B.MEGA
  • C.MICRO
  • D.MACRO

24) Which of the following client component can be used for creating Repository?

  • A. Designer
  • B.Workflow Manager
  • C.Repository Manager
  • D.Repository Server Administration Console

25) What does an informatica variable contains?

  • A. startvalue/end value
  • B.start value/current value
  • C.start value/dynamic value
  • D.start value/persistent value

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
CICS MCQ
01st
Jul
MS Word MCQ