Getting into Data Warehouses and theoretical concepts of ETL – 31st August, 2015

Did quite a bit of theory today (The Data Warehouse ETL Toolkit – by Kimball and Caserta/Wiley).

Some key points:

  •  Chapter 1 from the book.
  • Getting into the basics of Data Warehousing, Staging Areas
  • Process Check: Planning & Design – Requirements –> Architecture –> Implementation –> Test/Release
  • ETL Tool versus Hand Coding .. Advantages and disadvantages
  • Staging Data
Advertisements

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