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

  1. Home

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

Posted on by Online Exam TestTeam

More MCQS

  1. Informatica IPaaS MCQ Question Answer
Search
Olete Team
Online Exam TestTop Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Testwebsite 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!