Home > ETL Best Practices > The Hybrid Bus Approach

The Hybrid Bus Approach

This is a relevant topic for designing a staging area with a hybrid bus architecture.

From the ETL Toolkit book:

“Throughout this book, we support the judicious use of normalized data
structures for data cleaning
. A really dirty data source benefits from the
discipline of enforcing the many-to-1 relationships brought to the surface
by the process of normalization. THEN we urge the ETL team to convert
any such normalized structures into simple dimensional structures for the
conforming and final handoff steps
. This includes the atomic base layer of
data. At this point, an IT organization that has already invested in normalized
physical structures can leverage that investment. We can call this the
Hybrid Bus Approach.”

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: