O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required