Informatica MCQs Set: 2

Informatica MCQs Set: 2

Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge.

Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

The questions might have one or more answers.

 Q1. Which of the following are active Transformations?

(a) Sorter

(b) Expression

             (c) Normalizer

(d) Filter

 NOTE:

            Transformations are of 2 types:

·         Active à no. of rows changes from source and target

·         Passive à no. of rows remains the same in source and target

Transformations can be either CONNECTED or UN-CONNECTED.

Connected à Transformation has connection between transformations or directly to target.

Un-Connected à There is no physical connection between transformations. It is generally called inside another transformation.

TRANSFORMATION	ACTIVE/PASSIVE	CONNECTED/UN-CONNECTED
Aggregator	Active	Connected
Filter	Active	Connected
Joiner	Active	Connected
Normaliser	Active	Connected
Rank	Active	Connected
Router	Active	Connected
Sorter	Active	Connected
Source qualifier	Active	Connected
Update strategy	Active	Connected
Advanced External procedure	Active	Connected
External procedure	Active	Connected/ un-connected
Sequence generator	Passive	Connected
Expression	Passive	Connected
XML source qualifier	Passive	Connected
Stored procedure	Passive	Connected/ un-connected
Look up	Passive	Connected/ un-connected

 Q2. Which Function(s) cannot be used in Expression Widget(doubt)

(a) AVG

(b) COUNT

(c) LTRIM

            (d) RTRIM 

REASON:

            Expression transformation can perform only non aggregate functions.

Q3. Write down the standards for the following

Input Port                   ->     i_

Output Port                ->     o_

Variable Port             ->     v_

Q4. What manages the scheduling and execution of workflows?

(a) Informatica Server/Integeration services

(b) Repository Server

(C) Designer

(d) Monitor

REASON:

            Informatica service à Scheduling and Execution of Workflows.

            Repository service à Manages Metadata & Repository Connection Requests.

            Designer à has 5 tools(Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer), using which we can create Mappings.

            Monitor àmonitors workflows and tasks.

Q5. Which Client component can be used for creating Repository?

(a) Repository Manager

(b) Designer

(c) Workflow Manager

(d) Repository Server Administration Console

Q6. In Sequence Generator, If Current Value = 10, Increment By value=1, what is the NextVal value?

(a)   9

(b) 10

(c) 11

(d) 12

NOTE:

            NEXTVAL is always CURRENT VALUE + INCREMENT VALUE.

Q7. Can an Output Port be used in the editable area of widgets

(a) Yes

(b) No

(c) Depends on Widgets

(d) Possible only in active Transformation

REASON:

            Ports- Input, Output, Variable, Return/Rank, Lookup and Master? Variable ports are used to store intermediate results. Variable ports can reference input ports and variable ports, but not output ports.

Q8. If Sorted Input of Aggregator is unchecked,

(a) Sorter must be used before aggregator

(b) Sorter must be used after aggregator

(c) Sorter must be used before aggregator if data is not sorted via Source Qualifier

(d) Sorter must be used after aggregator if data is not sorted in Source Qualifier

REASON:

            The Aggregator with 'sorted input' unchecked always sorts the data prior to aggregation. So in order to increase performance we should have a sorter before sending the data to the aggregator.

Q9. Which of the following is/are better option if all below satisfies the requirement

(a) Filter Transformation used near to Source Qualifier

(b) Filter Transformation used near to Target

(c) Filter Transformation used anywhere in the mapping

(d) Filter Transformation used after any active transformation

REASON:

            Always try to use filter and sorter transformation near source qualifier, this will increase the performance. It is not mandatory but prescribed.

Q10. Which of the following is/are true?

(a) Shortcuts can be created for any object from any folder

(b) Shortcuts can be created for any object from shared folder

(c) Shortcuts can be created for sources and targets alone from any folder

(d) Shortcuts can be created for sources and targets alone from shared folder

 REASON:

A shortcut is a reference (link) to an object in a shared folder, these are
commonly used for sources and targets that are to be shared between
different environments / or projects. A shortcut is created by assigning
'Shared' status to a folder within the Repository Manager and then dragging
objects from this folder into another open folder