Did you know? SQL Server 2008 includes Cache TransformSQL Server 2008 includes Cache Transform: The Cache Transform transformation writes data from a connected data source in the data flow to a Cache connection manager. The cache can be populated from text files, XML files, Excel files, etc.; you are not limited to only populating the cache from an OLE DB source. The Lookup transformation in a package performs lookups on the data using the Cache connection manager. You can configure the Cache connection manager to save the data to a cache file (.caw). The cache file can be populated once and reused throughout the ETL process within multiple Lookup transformations for performing surrogate key lookups and populating the data warehouse. code pour embarquer la vidéo : >>> http://www.youtube.com/embed/GEloiitNtkU <<< |