Home > ETL Best Practices > Data-staging area – Normalize or not normalize

Data-staging area – Normalize or not normalize

Remember that the main result of normalization is to enforce specific many-to-1 relationships.

According to the ETL Toolkit book, we should not assume that the data-staging area must be normalized. Remember two of the goals for designing your ETL processes: Make them fast and make them recoverable. If you have stages in your process that are not physically manipulating data and do not enable speed or recoverability, they ought to be removed.

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: