Informatica PR000041 Exam Questions - Real Practice Questions for Guaranteed Success

Question 1

The word FALSE is a valid Filter transformation condition?

ATrue

BFalse

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ATrue

BFalse

0 / 1500

Question 2

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

AROUND

BTRUNC

CINSTR

DCONCAT

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AROUND

BTRUNC

CINSTR

DCONCAT

0 / 1500

Question 3

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

Correct : D

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

0 / 1500

Question 4

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

Correct : A

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

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

0 / 1500

Question 5

Which of the following techniques could be used to filter data read from a flat file source?

ACreate a valid condition in the Filter attribute of the flat file's Source Qualifier

BPlace a Filter transformation directly after the flat file's Source Qualifier

CAn Expression transformation with an output port's expression defined to filter records

DAn Expression transformation with all of the output port's default values set to blank

Correct : B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ACreate a valid condition in the Filter attribute of the flat file's Source Qualifier

BPlace a Filter transformation directly after the flat file's Source Qualifier

CAn Expression transformation with an output port's expression defined to filter records

DAn Expression transformation with all of the output port's default values set to blank

0 / 1500

Master Informatica PR000041 Exam with Reliable Practice Questions

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users:

Options Selected by Other Users: