Informatica IPaaS/Informatica IPaaS MCQ Question Answer Sample Test,Sample questions

Question:
 if you have a session named 's_m_employee_detail' then workflow for the same can be named as '___'.

1.wkf_s_m_employee_detail

2.s_m_employee_detail_wkf_

3. s_m_employee_detail.wkf_

4. All of the above


Question:
 Informatica is a software development company founded in ...............

1. 1990

2.1991

3.1992

4.1993


Question:
 Integration service is the ___ for the Informatica.

1. executing engine

2. ETL Tool

3. SOA

4.None of the above


Question:
 What are the two types of Repositories in INFORMATICA?

1.Global Repositories

2.Local Repositories

3.National Repositories

4. Both A & B


Question:
 What does an informatica variable contains?

1. startvalue/end value

2.start value/current value

3.start value/dynamic value

4.start value/persistent value


Question:
 What is the full form of OLAP?

1.On-Line Analytical Processing

2.On-Line Analysis Processing

3.On-Line Access Processing

4. On-Line Application processing


Question:
 What is the purpose of SQL override?

1. It is used to write user defined SQL statements in source qualifier and look up transformations.

2.Write to cache files

3.Performance tuning

4.None of the above


Question:
 Which of the following client component can be used for creating Repository?

1.Designer

2.Workflow Manager

3.Repository Manager

4.Repository Server Administration Console


Question:
 Which of the following is not an ETL tool?

1.Datastage

2.Informatica

3.Visual studio

4.DT/studio.


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

1.Temp server

2.Repository server

3.Domain server

4. Powerhouse server


Question:
 Which of the following transformation is used to combine data from different sources?

1.Union Transformation

2.Joiner transformation

3.Joiner transformation

4.Expression transformation


Question:
 Which of the following transformation is used to convert the rows in to columns?

1.Filter Transformation

2. Source Qualifier

3.Normalizer Transformation

4.Router Transformation


Question:
 Which of the following transformation is used to handle cobol sources?

1.Filter Transformation

2.Source Qualifier

3. Normalizer Transformation

4.Expression Transformation


Question:
 Which of the following transformation is used to handle cobol sources?

1. Source Qualifier

2.Normalizer Transformation

3.Filter Transformation

4.Expression Transformation


Question:
 Which of the following Transformation is used to load the rejected records?

1.Source Qualifier

2.Router Transformation

3.Filter Transformation

4.None of the above


Question:
 Which process is used for online analytical processing?

1.Data

2.Database

3.Data mart

4.Data warehouse


Question:
............... test is used in an online transactional processing environment.

1.ACID

2.MEGA

3.MICRO

4.MACRO


Question:
A partition executes in a________.

1. single reader, or writer thread

2.multiple reader, transformation, or writer thread

3.single reader, transformation, or writer thread

4.single reader, multiple transformation, or multiple writer thread


Question:
Different Components of PowerCenter?

1. Repository Service

2.PowerCenter Clients

3.PowerCenter Service

4.All of the above


Question:
Flatfile cannot be used for

1. Aggregator

2.Source

3.Lookup

4.Target


Question:
OLAP stands for______

1.On-Line Access Processing

2.On-Line Analysis Processing

3.On-Line Analytical Processing

4.On-Line Application processing


Question:
Parameters are created in which tool?

1.Designer

2.Workflow monitor

3.Repository manager

4.Admin console


Question:
Reusable component in Informatica are:

1. Session

2.Workflow

3.Mapplet

4.Mapping


Question:
The repository server create and update the repository tables through 

1.Native drivers

2. LAN Drivers

3.PSTN Lines

4.Repository agent process


Question:
Two types of Repositories in Informatica are:

1. Local Repositories

2.Global Repositories

3.National Repositories

4.Both A & B


Question:
Type of relationship in star schema is______

1. one-to-one.

2.one-to-many.

3.many-to-one.

4.many-to-many.


Question:
What are the services & components of the Informatica ETL tool?

1. Informatica Designer

2.Workflow Monitor

3. Repository Manager

4. All of the above


Question:
What ETL Stands for_____

1. Extract, Transform, Load

2.Extreme, Transform, Load

3.Enable, Transactions, Load

4.None of the above


Question:
What is the function of SCD (Slowly Changing Dimension)?

1.manage data

2.manage workflow

3.manage session

4. None of the above


Question:
Which Component gets metadata from Repository?

1. Informatica Server

2.Informatica Designer

3.Informatica Workflow Designer

4.Informatica Repository service


Question:
Which of the following cashes used in informatica?

1. Static

2.Dynamic

3.dynamic,static

4.Dynamic,Static,persistent


Question:
Which of the following component of informatica is used to see the performance of the workflow while running?

1.Mapping Designer

2. Workflow Monitor

3.Worklet Designer

4.Workflow Manager


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

1. AVG

2.TRIM

3.LTRIM

4.RTRIM


Question:
Which of the following option is need to be checked for creating shortcuts for folders?

1. Shortcuts

2.Create Shortcuts

3.Allow shortcut

4.None of the above


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

1.DD_UPDATE

2.DD_INSERT

3. Data Driven

4.DD_REJECT


Question:
Which of the following transformation is not using to connect more than one table?

1.joiner

2.source qualifier

3.lookup

4. sorter


Question:
Which of the following transformation is used to combine data from different sources?

1.Lookup transformation

2.Joiner transformation

3.Union Transformation

4.Expression transformation


Question:
Which of the following types of sources are available in informatica?

1.Flatfiles

2.Cobol and XML sources

3.Homogeneous & Heterogeneous

4.All of the above


Question:
Which one is not an active transformation?

1.Store Procedure

2.Sequence generator

3.SQL

4.Normalizer


Question:
Which one is not correct about filter transformation?

1. Passes multiple conditions

2.Can't passes multiple conditions

3.Act like 'Case' in pl/sql

4.Act as a 'where' condition


Question:
Which one is reusable component in Informatica?

1. Mapping

2.Mapplet

3. Session

4. Workflow


Question:
Which schema is a good alternative to the star schema.

1. Star schema.

2.Fact constellation.

3.Snowflake schema.

4.Star-snowflake schema.


Question:
Which task is used anywhere in the workflow to run the shell commands?

1. Session Task

2.email Task

3.Command Task

4.Standalone Command Task


Question:
___ are objects which can be referenced throughout the mapping run (to access their values) and their values can be reassigned.

1.Mapping variables

2.Mapping Parameters

3. Mapping designer

4.All of the above


More MCQS

  1. Informatica IPaaS MCQ Question Answer
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!