ETL and ELT #

The sub pages here focus mainly on Data Modeling, SQL pitfalls and performance optimization.

1. Data Modeling - Pragmatic considerations especially for choosing between One Big Table (OBT) and a Star Schema.
2. SQL Optimization - Focusses on hopefully not so obvious SQL performance optimization.
3. SQL Pitfalls - Focusses on common and not so common pitfalls to be aware of when coding SQL.