Which of the following is a reason for doing the task given here?
You are in the process of creating a data flow to load sales data into a fact table. You have configured a full cache mode Lookup Transformation in the data flow to find the product data for sales. Two tables host the lookup source for the product data.You then access the Advanced Page of the Lookup Transformation Editor.
A. To configure a suitable connection manager. B. To configure partial caching. C. To modify the SQL statement for the Lookup transformation. D. To specify the join between the source table and the reference table.