Which of the following is a reason for doing the task given here? - ProProfs Discuss
Topics
Products
Follow Us:

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.

This question is part of MSBI SSIS Quiz
Asked by LmAkshay, Last updated: Jul 04, 2020

+ Answer
Request
1

3 Answers

sony

Sony

Answered Nov 10, 2018

D. To specify the join between the source table and the reference table.

 

John Adney

John Adney

Answered Oct 03, 2017

To specify the join between the source table and the reference table.

 

John Smith

John Smith

Answered Jun 10, 2017

To configure a suitable connection manager.

####
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.