You work as a database administrator at Abc.com. You are responsible for creating a SQL Server 2008 Integration Services (SSIS) instance. The SSIS instance contains a Data Flow task that reproduces millions of rows for Abc.com. The data flow checks for a match against a reference table that contains of 50,000 rows, including every row that will be used during the data flow. You need to ensure that the data flow runs in the least amount of time. What should you do?
1)You should consider selecting a Lookup transformation in conjunction with the half cache option. 2)You should consider selecting a Lookup transformation in conjunction with the Full cache option. 3)You should consider selecting a default Lookup transformation in conjunction with a Data Conversion transformation. 4)You should consider selecting a Lookup transformation in conjunction with the Default cache option. PreviousNext
Suggest other answer Login to Discuss/suggest the answer...
You can help us to improve by giving your valuable suggestions at email@example.com
By using the service of this site, I agree that I will serve wholeheartedly
and will not indulge in any sort of activity that threats the integrity of the organisation I am working for / I work for.
I have a firm believe in the notion that knowledge should be open source and
helping the needy and deserving part of society will always be my motto.
Knowledge is the power, Dont miss any paper, Subscribe to us