New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

PR000041 Questions and Answers

Question # 6

Can you use a Decode function to perform multiple searches based on a single search value?

A.

No

B.

Yes

C.

Yes, but only if the port being searched Is sorted first

D.

Yes, but only if the port is downstream of a router transformation

Full Access
Question # 7

Which of the following is true about database connections?

A.

Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS

B.

PowerCenter connections may be created In either the Administrator or the Workflow Manager

C.

MRS connections may be created in either the Workflow Manager or the Administrator

D.

Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories

Full Access
Question # 8

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

A.

Expression and Update Strategy

B.

Update Strategy

C.

Update Strategy and Lookup

D.

Expression, Aggregator, and Update Strategy

Full Access
Question # 9

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

A.

Option A

B.

OptionB

C.

OptionC

D.

OptionD

Full Access
Question # 10

Which of these statements is correct concerning a Lookup transformation's persistent cache?

A.

A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

B.

persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

C.

When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

D.

A persistent cache can only be used by one mapping

Full Access