File Info
| Exam | PowerCenter Data Integration 9.x:Developer Specialist |
| Number | PR000041 |
| File Name | Informatica.PR000041.CertDumps.2015-10-26.70q.vcex |
| Size | 528 KB |
| Posted | Oct 26, 2015 |
| Download | Informatica.PR000041.CertDumps.2015-10-26.70q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which is the correct priority of assigning a mapping variable?
- Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value
- Session parameter file, workflow parameter file, repository value, declared initial value
- Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
- Repository value, declared initial value, default value
Correct answer: A
Question 2
Which command line tool would you use to execute a workflow?
- infasetup
- infacmd
- pmcmd
- pmrep
Correct answer: C
Question 3
What is a pipeline lookup transformation?
- A lookup created using a pipeline which contains a target
- A lookup cache split over pipelines of a partitioned mapping
- A lookup associated with the Source Qualifier or an Application source such as JMS or SAP
- A pipeline lookup does not exist
Correct answer: C
Question 4
Which of the following is a reusable task available in workflow manager?
- Decision
- Assignment
- Control
- Command
Correct answer: B
Question 5
The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?
- Pass-through
- Hash auto-keys
- Not a valid partition points
- Based on the transformation scope
Correct answer: B
Explanation:
answer is up-to-date. answer is up-to-date.
Question 6
When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)
- Filter, Joiner, Rank
- Union, Filter, Aggregator
- Rank, Lookup, Aggregator
- Joiner, Rank, Sorter
Correct answer: D
Question 7
Given a Union transformation with 2 input groups, which statement is correct and true?
- Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
- Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.
- When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
- The port names in each input group can be named the same.
Correct answer: A
Question 8
A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)
- Read permissions on the two folders
- Read permissions on the two folders as well as have both folders opened
- Full access (Read, Write and Execute permissions) on both folders
- Mappings cannot be compared across folders using PowerCenter Designer
Correct answer: B
Question 9
Which one of the following transformations may be unconnected In a valid mapping? (choose one)
- Lookup, stored procedure, external procedure
- Lookup, stored procedure, Java
- Java, lookup, transaction control
- Transaction control, Java, lookup
Correct answer: A
Question 10
Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?
- True
- False
Correct answer: A
