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

Question

Quizplus · Accepted Answer

The index cache contains the fields that are part of the join condition, which are 2 in this case. The data cache contains all the fields that are connected downstream to the next transformation, which are 5 in this case.

Assuming That the Master Pipeline Has 5 Fields, Two of Which