Explanation:As long as the source can handle many concurrent connections, you may see an increase in throughput if you start several extracts at once. 3. When you execute SQL statements within Integration Services, the following optimization can be made ?
A. If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance
B. In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
C. If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing.
D. All of the mentioned
Answer:A
Explanation:As long as the source can handle many concurrent connections, you may see an increase in throughput if you start several extracts at once. 3. When you execute SQL statements within Integration Services, the following optimization can be made ?
A. If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance B. In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache C. If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing. D. All of the mentioned
Explanation:When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache. 4. Which of the the following steps should be carried out using data types in SSIS for efficient results ?