HOTSPOT
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:
According to these references, this answer looks correct.
References:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/ms189697.aspx
Per MSDN:
Lookup Transformation Editor (Columns Page)
SQL Server 2012 Other Versions
Use the Columns page of the Lookup Transformation Editor dialog box to specify the join between the source table and the reference table, and to select lookup columns from the reference table.
So, isn’t the answer ‘Columns’?
No, its correct. The question is “…configure the query…” then, if you change the query it will reflects in columns. However, the correct answer is “Connection”.
Connection
Connection is correct.
After, choose the option “Use results of an SQL query” and so, build the query to combine the two tables.