Informatica PR000041 ICP Practice Questions| TestInsights

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

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

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

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

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

Curious about Actual Informatica ICP (PR000041) Exam 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: