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
