Informatica PR000041 ICP Exam Practice Test Instant Access

Question 1

What is a pipeline lookup transformation?

AA lookup created using a pipeline which contains a target

BA lookup cache split over pipelines of a partitioned mapping

CA lookup associated with the Source Qualifier or an Application source such as JMS or SAP

DA pipeline lookup does not exist

Answer : C

Question 2

Which of the following is a reusable task available in workflow manager?

ADecision

BAssignment

CControl

DCommand

Answer : B

Question 3

Referring to the Sequence Generator transformation, which statement is correct and true?

AThe NextVal column produces the next number in the sequence

BThe cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

CThe default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

DThe Sequence Generator contains a single input port that represents the initial starting point of the sequence

Answer : A

Question 4

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

AIf a transformation's Active property is cleared or not enabled, the transformation becomes passive

BA transformation is active if it does not change the number of rows in the pipeline

CTransformations can be active and passive at the same time

DA passive transformation will not change the number of rows in the pipeline

Answer : D

Question 5

Subqueries can be used in the SQL override for uncached lookup transformations.

ATrue

BFalse

Answer : B

Question 6

Which of the following statements is correct on workflow events?

AA predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping

BA user-defined event can be created a-d raised in one workflow and then used In another

CA predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.

DA user-defined event can be created in either the Event Wait or Event Raise task

Answer : C

Question 7

Which of following statements is valid for Dynamic lookups?

ADynamic caching cannot be enabled on a lookup that returns multiple rows per search

BA dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

CA dynamic lookup must be cached and persistent

DIt is possible to update and delete records in a dynamic lookup

Answer : A

Informatica PR000041 PowerCenter Data Integration 9.x:Developer Specialist ICP Exam Practice Test