Which page of the Lookup Transformation Editor should you select to configure the query?

HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you
configure a Lookup 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 Transformation Editor should you select to configure the query?
To answer, select the appropriate page in the answer area.

HOTSPOT
You are developing a data flow to load sales data into a fact table. In the data flow, you
configure a Lookup 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 Transformation Editor should you select to configure the query?
To answer, select the appropriate page in the answer area.

Answer:

Explanation:

http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/ms189697.aspx



Leave a Reply 4

Your email address will not be published. Required fields are marked *


moogaloo

moogaloo

Advanced is where you can specify a query, so I think Advanced

Raul

Raul

Connection Manager is definitely correct.

You Select Connection Manager -> Data Access Dropdown -> SQL Command Text

Stan

Stan

The advanced tab you can modify the query, that is for: Modify the SQL statement that is used to generate the reference dataset.