1 - Term
- ETL : Extraction, Transformation and Load Software
- ELT : Extraction, Load and Transformation Software
- Do it once at night vs. do it every time for a query
- The “360 degree view of the enterprise” is a commonly discussed goal that really means data integration.
2 - Performance Note
A full Data Vault loading cycle might take 40 or 50 minutes total time, (50 staging tables, 1 terabyte incomming data) – where a so-called “traditional” (type 2 dimension + facts) loading cycle for the same data sets would take about 3 to 4 hours…. It can all happen in PARALLEL…