July 25, 2018

Informatica PowerCenter - MCQS


Question.
In a Workflow , you need to run an operating system script between two sessions. How can you best accomplish this?
a)Call from Post SQL
b)Call the script from a Command task
c)Use a custom transformation
d)Use Event raise and Event wait tasks

Answer: Call the script from a Command task

Question.
An Active Transformation :

a)Does not change the number of rows that pass through it
b)Represents the data flow between sources and targets
c)Can change the number of rows that pass through it
d)Creates a target definition based on a source definition

Answer: Can change the number of rows that pass through it

Question.
NetSal= bassic+hra. In which transformation we can achieve this?

Lookup
Expression
Filter
Aggregator

Answer: Expression

Question.
How many return ports are allowed in unconnected lookup transformation ?

3
2
1
Any number

Answer: 1

Question.
Which one is not correct about filter transformation?

Act as a 'where' condition
Can't passes multiple conditions
Act like 'Case' in pl/sql
If one record does not match condition, the record is blocked

Answer: Act as a 'where' condition

Question.
Are user-defined events supported in PowerCenter workflows?

a)No, because only File Wait events are supported in the Event-Wait task.
b)Yes, but only in workflows containing worklets.
c)No, because Event-raise tasks do not support user-defined events.
d)Yes, using a combination of Event-Raise and Event-Wait tasks

Answer: Yes, using a combination of Event-Raise and Event-Wait tasks

Question.
Every mapping must contain which of the following components :

a)Source definition
b)Target definition
c)Source definition, Target definition, Transformation, Links
d)Source and Target definition

Answer: Source definition, Target definition, Transformation, Links

Question.
Which transformation is used to combine data from different sources?

Lookup
Joiner
Union
Expression

Answer: Union

Question.
Aggregator Transformation performs :

a)calculation of values in a single row
b)concatenation of columns/ports in a row
c)aggregate calculations, such as averages and sums
d)calculations on a row-by-row basis

Answer: aggregate calculations, such as averages and sums

Question.
For triming leading & trailing spaces of a in Informatica the following function is used

a)TRIM(VALUE)
b)LTRIM(VALUE)
c)LTRIM(RTRIM(VALUE))
d)AllTRIM(VALUE)

Answer: LTRIM(RTRIM(VALUE))

Question.
In Joiner Transformation, if Master Outer Join type is used, it will :

a)Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source
b)Discard all rows of data from the master and detail source that do not match, based on the condition
c)Keep all rows of data from the master source and the matching rows from the detail source, and discards the unmatched rows from the detail source
d)Keep all rows of data from both the master and detail sources

Answer: Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source

Question.
Chrological details of workflow tasks can be viewed in

a)Gantt chart view
b)task view
c)Workflow view
d)we cant view chronological details in worklow monitor

Answer: Gantt chart view

Question.
Which transformation only works on relational source?

Lookup
Joiner
Union
SQL

Answer: SQL

Question.
A transformation that does not change the number of rows that pass through it, is called :

a)Passive Transformation
b)Connected Transformation
c)Mapplet
d)Source Qualifier

Answer: Passive Transformation

Question.
which command is used to execute workflow tasks from the command line

REPCMD
PMCMD
CMD
PMREP

Answer: PMCMD

Question.
Which of the following transformations does not have variable port ?

Filter
Expression
Rank
Aggregator

Answer: Filter

Question.
A set of instructions to execute tasks such as sessions, emails, shell commands etc is called :

a)Mapping
b)Load Balancer
c)Workflow
d)Transformation

Answer: Workflow

Question.
Which of the following is a type of workflow task?

Ranking
Database Bulk Loading
sorting
Event Raise

Answer: Event Raise

Question.
Which of the following is not a Active Transformation ?

Router
Filter
Sequence Generator
Update Strategy

Answer: Sequence Generator

Question.
How to execute PL/SQL script from Informatica mapping?

Lookup
Store Procdure
Expression
Non of these
Answer: Store Procdure

Question.
What is a mapplet?

Combination of reusable transformation.
Set of transformations and it allows us to reuse
None of these

Answer: Set of transformations and it allows us to reuse

Question.
Which one is not a type of  fact?

Semi-aditive
Additive
Confirm fact
Not additive

Answer: Confirm fact

Question.
Which one is not a type of dimension ?

Conformed dimension
Rapidly changing dimension
Junk dimension
Degenerated dimension

Answer: Rapidly changing dimension

Question.
What does reusable transformation mean?

It can be re-used across repositories
I can only be used in mapplet.
It can use in multiple mapping only once
It can use in multiple mapping multiple times

Answer: It can use in multiple mapping multiple times

Question.
Which one is not an option in update strategy?

dd_reject
4
2
dd_delete

Answer: 4