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
C is the correct answer.
Explication:
– There are 2 types of cache memory, index and data cache.
– All rows from the master source and loaded into cache memory.
– > The index cache contains all ports values from the master source where the port is specified in the join condition.
– > The data cache contains all port values not specified in the condition.
– After the cache is loaded the detail source is compared row by row to the values in the index cache.
– Up on match the row from the data cache are included in the stream.
– Cache is created only for master source
I think its C
I think its C
port used in join condition will be stored in Index cache and all master/output ports will be in Data Cache
so the answer is: D
Wrong answer;
” port used in join condition will be stored in Index cache and Output ports will be in Data Cache”
so the answer is: D
I think it should be C, since that”data cache contains those ports values not specified in join condition”