Question No. 1

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

AAn unconnected lookup can return multiple rows while a connected lookup may return only one

BBoth connected and unconnected lookups can return multiple rows

CAn unconnected lookup may return only one value while a connected lookup may return multiple rows

DBoth connected and unconnected lookups can return only one row

Show Answer

Correct Answer: C

Question No. 2

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

Show Answer

Correct Answer: D

Question No. 3

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

ASTATE

B'CA'

CNULL

DValue of the PREVI0US_STATE port is based upon its declared default value

Show Answer

Correct Answer: B

Question No. 4

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

ARecords that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly

BRecords that are tagged for rejection are dropped and not projected downstream to the next transformation

CThe Forward Rejected Rows attribute cannot be cleared after the transformation is created

DThe Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Show Answer

Correct Answer: B

Question No. 5

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

Show Answer

Correct Answer: C

Free Informatica PR000041 Exam Actual Questions

The questions for PR000041 were last updated On Dec 20, 2024