Informatica
PR000041
Q1:
Which of the following techniques could be used to filter data read from a flat file source?
○
A
Create a valid condition in the Filter attribute of the flat file's Source Qualifier○
B
Place a Filter transformation directly after the flat file's Source Qualifier○
C
An Expression transformation with an output port's expression defined to filter records○
D
An Expression transformation with all of the output port's default values set to blank
Informatica
PR000041
Q2:
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?
○
A
5 fields are in the index cache and 3 are in the data cache○
B
3 fields are in the index cache and 2 fields are in the data cache○
C
2 fields are in the index cache and 3 fields are in the data cache○
D
2 fields are in the index and 5 fields are in the data cache
Informatica
PR000041
Q3:
In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)
○
A
Character day of week, character day of month, and character day of year respectively○
B
Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively○
C
Each produces numerical day of week○
D
Numerical day of week, day of month, and day of year respectively
Informatica
PR000041
Q4:
What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)
○
A
ROUND○
B
TRUNC○
C
INSTR○
D
CONCAT
Informatica
PR000041
Q5:
The word FALSE is a valid Filter transformation condition?
○
A
True○
B
False