Informatica MCQ Questions

Informatica MCQ Questions

  • Sharad Jaiswal
  • 23rd Nov, 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.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

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.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Nov
Digital Marketing MCQ

Digital Marketing MCQ

01st
Jun
Jenkins MCQ Questions

Jenkins MCQ Questions

01st
Nov
RDBMS MCQ

RDBMS MCQ

01st
Dec
Compiler Design MCQ Questions

Compiler Design MCQ Questions

01st
Feb
Agile Scrum MCQ

Agile Scrum MCQ

01st
Jun
Devops mcq

Devops mcq