Microsoft
70-448 · Question #341
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to upgrade a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package performs an extract…
The correct answer is D. Add a Cache Transformation to populate the Lookup Transformation. See the full explanation below for the reasoning.
Question
You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to upgrade a Microsoft SQL Server 2005 Integration Services (SSIS) package. The package performs an extract, transform, and load (ETL) process for a sales data warehouse. You discover that the Lookup Transformation process runs slow. The package uses only OLE DB sources and destinations. You need to optimize the performance of the process that populates the Fact tables. What should you do?
Options
- AAdd a Fuzzy Lookup Transformation.
- BAdd an Import Column Transformation.
- CAdd a Raw File Source to populate the Lookup Transformation
- DAdd a Cache Transformation to populate the Lookup Transformation.
How the community answered
(30 responses)- A3% (1)
- B10% (3)
- C17% (5)
- D70% (21)
Community Discussion
No community discussion yet for this question.