You are developing a data flow to load sales data into a fact table. In the data flow, you configure aLookup
Transformation in full cache mode to look up the product data for the sale. The lookup source for the product
data is contained in two tables. You need to set the data source for the lookup to be a query that combines the
two tables. Which page of the Lookup TransformationEditor should you select to configure the query? To
answer, select the appropriate page in the answer area.
Answer:
Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/ms189697.aspx
Advanced
Connection, not Advanced. Advanced is only available for partial cache mode. Question states full cache mode explicitly. Connection SQL is executed during pre-execute phase. Advanced SQL is executed during data-flow when the reference row is not in the cache (cache miss).
Connection. This is where you specify your lookup data (table/view or custom SQL)
Connection