You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
According to the requirement of the company, you’re desinging a SQL Server 2008 Integration Services (SSIS) package.
The package contains a Data Flow task which copies several million rows. There is a reference table that contains 10,000 rows.
The data flow needs a match against the reference table. During the data flow, each row in the reference table will be used.
You must make sure that the data flow takes as little time to execute as possible. Of the following data flow components, which one should you use?
A.
You should use a Fuzzy Lookup transformation
B.
You should use a Lookup transformation along with the No cache option
C.
You should use a Lookup transformation along with the Full cache option
D.
You should use a Lookup transformation along with the Partial cache option