Olete.in – MCQs, Mock Tests & Government Job Prep | Informatica IPaaS Informatica IPaaS MCQ Question Answer

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

✅ Correct Answer: 2

Reusable component in Informatica are:

1. Session
2. Workflow
3. Mapplet
4. Mapping

✅ Correct Answer: 3

OLAP stands for______

1. On-Line Access Processing
2. On-Line Analysis Processing
3. On-Line Analytical Processing
4. On-Line Application processing

✅ Correct Answer: 3

Two types of Repositories in Informatica are:

1. Local Repositories
2. Global Repositories
3. National Repositories
4. Both A & B

✅ Correct Answer: 4

What ETL Stands for_____

1. Extract, Transform, Load
2. Extreme, Transform, Load
3. Enable, Transactions, Load
4. None of the above

✅ Correct Answer: 1

Which of the following is not an ETL tool?

1. Datastage
2. Informatica
3. Visual studio
4. DT/studio.

✅ Correct Answer: 3

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

✅ Correct Answer: 3

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

1. Informatica Designer
2. Workflow Monitor
3. Repository Manager
4. All of the above

✅ Correct Answer: 4

Integration service is the ___ for the Informatica.

1. executing engine
2. ETL Tool
3. SOA
4. None of the above

✅ Correct Answer: 1

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

✅ Correct Answer: 4

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

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

1. Filter Transformation
2. Source Qualifier
3. Normalizer Transformation
4. Expression Transformation

✅ Correct Answer: 3

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

✅ Correct Answer: 3

___ 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

✅ Correct Answer: 1

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

✅ Correct Answer: 1

Parameters are created in which tool?

1. Designer
2. Workflow monitor
3. Repository manager
4. Admin console

✅ Correct Answer: 1

Which of the following cashes used in informatica?

1. Static
2. Dynamic
3. dynamic,static
4. Dynamic,Static,persistent

✅ Correct Answer: 4

Which schema is a good alternative to the star schema.

1. Star schema.
2. Fact constellation.
3. Snowflake schema.
4. Star-snowflake schema.

✅ Correct Answer: 2

Type of relationship in star schema is______

1. one-to-one.
2. one-to-many.
3. many-to-one.
4. many-to-many.

✅ Correct Answer: 2

Flatfile cannot be used for

1. Aggregator
2. Source
3. Lookup
4. Target

✅ Correct Answer: 1

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

✅ Correct Answer: 1

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

1. Source Qualifier
2. Normalizer Transformation
3. Filter Transformation
4. Expression Transformation

✅ Correct Answer: 3

Different Components of PowerCenter?

1. Repository Service
2. PowerCenter Clients
3. PowerCenter Service
4. All of the above

✅ Correct Answer: 4

Which one is reusable component in Informatica?

1. Mapping
2. Mapplet
3. Session
4. Workflow

✅ Correct Answer: 2

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

✅ Correct Answer: 3

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

✅ Correct Answer: 4

Which process is used for online analytical processing?

1. Data
2. Database
3. Data mart
4. Data warehouse

✅ Correct Answer: 4

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

1. joiner
2. source qualifier
3. lookup
4. sorter

✅ Correct Answer: 4

Which Component gets metadata from Repository?

1. Informatica Server
2. Informatica Designer
3. Informatica Workflow Designer
4. Informatica Repository service

✅ Correct Answer: 4

Which one is not an active transformation?

1. Store Procedure
2. Sequence generator
3. SQL
4. Normalizer

✅ Correct Answer: 2

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

1. 1990
2. 1991
3. 1992
4. 1993

✅ Correct Answer: 4

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

1. AVG
2. TRIM
3. LTRIM
4. RTRIM

✅ Correct Answer: 1

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

1. ACID
2. MEGA
3. MICRO
4. MACRO

✅ Correct Answer: 1

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

✅ Correct Answer: 4

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

✅ Correct Answer: 2

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

✅ Correct Answer: 1

The repository server create and update the repository tables through

1. Native drivers
2. LAN Drivers
3. PSTN Lines
4. Repository agent process

✅ Correct Answer: 4

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

✅ Correct Answer: 3

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

✅ Correct Answer: 2

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

1. manage data
2. manage workflow
3. manage session
4. None of the above

✅ Correct Answer: 1

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

✅ Correct Answer: 3

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

✅ Correct Answer: 2

What are the two types of Repositories in INFORMATICA?

1. Global Repositories
2. Local Repositories
3. National Repositories
4. Both A & B

✅ Correct Answer: 4