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

Question

Quizplus · Accepted Answer

The data from the master pipeline is used to build the cache files in the Joiner transformation process. The master pipeline's data is cached because it is typically smaller, allowing for efficient joining with the detail pipeline's data.

When Using the Joiner Transformation and Assuming That You Are