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