Informatica PR000041 Exam Actual Questions

Name: PowerCenter Data Integration 9.x:Developer Specialist
Brand: QA4Exam
SKU: PR000041
Price: 30 USD
Availability: InStock
Rating: 4.8 (148 reviews)

The questions for PR000041 were last updated on Oct 3, 2024.

Viewing page 1 out of 14 pages.
Viewing questions 1-5 out of 70 questions

Unlock Access to All 70 Questions & Answers

Question No. 1

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. 2

The word FALSE is a valid Filter transformation condition?

ATrue

BFalse

Show Answer

Correct Answer: B

Question No. 3

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

AROUND

BTRUNC

CINSTR

DCONCAT

Show Answer

Correct Answer: A

Question No. 4

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

ACharacter day of week, character day of month, and character day of year respectively

BDay of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

CEach produces numerical day of week

DNumerical day of week, day of month, and day of year respectively

Show Answer

Correct Answer: D

Question No. 5

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

A5 fields are in the index cache and 3 are in the data cache

B3 fields are in the index cache and 2 fields are in the data cache

C2 fields are in the index cache and 3 fields are in the data cache

D2 fields are in the index and 5 fields are in the data cache

Show Answer

Correct Answer: A

Unlock All Questions for Informatica PR000041 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 70 Questions & Answers