Common ETL Package-Design Practices
Whether you start with the blank SSIS package project-type template in BIDS, or by using the Import and Export Wizard to create simple starter packages, your ETL solution may ultimately consist of many SSIS packages. Before you begin implementing any packages, you should take a bit of time to plan your ETL approach and high-level package design principles. The following list of common ETL practices is offered as a guide, based on our collective experience architecting and building enterprise BI systems: Create one set of packages for inserts and a different set for updates. Name the packages according to function.
- Create a minimum of one package for each dimension and fact table per action type (insert or ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
