Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q27: Can you use a Decode function to
Q28: Of the statements below, which best describes
Q29: From within your folder, is it possible
Q30: Assuming that the value of Fl is
Q31: Subqueries can be used in the SQL
Q33: How does a single joiner transformation join
Q34: When would a Lookup transformation be classified
Q35: Which of the following is not a
Q36: A user needs to compare mappings across
Q37: When the Transformation Scope is set to