When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?
A. The data from the detail pipeline Is used to build the cache files used In the join process
B. The data from the master pipeline is used to build the cache files used in the join process
C. The cache files are built according to a sql override found on the Joiner Properties tab
D. The Joiner transformation uses the database to build the join result