"Haste makes waste" is as true in data warehousing as it is in life. The faster we try to go, the longer it takes to arrive at our destination. When we rush, we fail to plan sufficiently and make careless mistakes.

I'm still amazed how many data warehousing projects gloss over the all-important step of scrutinizing source data before designing data models and ETL mappings. For example, one company designed its data model and extract, transform and load (ETL) scripts around a database that contained 11.5 million customers, only to realize later that it actually held only 1.5 million distinct customer records. This forced the firm to rewrite its target models at great expense.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access