Name: PowerCenter Data Integration 9.x:Developer Specialist
Brand: ValidExamDumps
SKU: PR000041
Price: 20 USD
Availability: InStock
Rating: 4.8 (405 reviews)

Free Informatica PR000041 Exam Actual Questions

The questions for PR000041 were last updated On Nov 18, 2024

Question No. 1

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

Question No. 2

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? function name{1, COMPANY, 'i' , 'I')

ACHOOSE

BREPLACECHR

CREG_REPLACE

DINSTR

Show Answer

Correct Answer: B

Question No. 3

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

AYes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

BYes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

CYes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

DNo

Show Answer

Correct Answer: C

Question No. 4

Which of the following Is NOT true of Aggregate functions?

AYou can place an aggregate function in a variable port

BYou can add a filter condition to calculate values for specific rows In the selected ports

CYou can use operators to perform arithmetic within the function

DYou can calculate a single value for all rows in a group

Show Answer

Correct Answer: A

Question No. 5

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