Ísis Santos Costa’s Reviews > The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling > Status Update
Ísis Santos Costa
is on page 462 of 608
p. 428
Kimball DW/BI Lifecycle Overview
↳ Common Pitfalls Auto Avoid
...↳ 1 Neglect business acceptance
...↳ 2 Presume requirements are static
...↳ 3 Load only summarized data
...↳ 4 Standalone dim. modeling w/o Data Architecture & conformed dim.
...↳ 5 Make supposedly queryable data overly complex
— Nov 01, 2025 03:54PM
Kimball DW/BI Lifecycle Overview
↳ Common Pitfalls Auto Avoid
...↳ 1 Neglect business acceptance
...↳ 2 Presume requirements are static
...↳ 3 Load only summarized data
...↳ 4 Standalone dim. modeling w/o Data Architecture & conformed dim.
...↳ 5 Make supposedly queryable data overly complex
Like flag
Ísis’s Previous Updates
Ísis Santos Costa
is on page 514 of 608
p. 480
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 17: Dimension Manager System
— Jan 04, 2026 07:12AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 17: Dimension Manager System
Ísis Santos Costa
is on page 513 of 608
p. 479
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 16: Late Arriving Data Handler
— Jan 03, 2026 05:14AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 16: Late Arriving Data Handler
Ísis Santos Costa
is on page 512 of 608
p. 478
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 15: Multivalued Dimension Bridge Table Builder
— Jan 02, 2026 08:05AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 15: Multivalued Dimension Bridge Table Builder
Ísis Santos Costa
is on page 511 of 608
p. 477
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 14: Surrogate Key Pipeline
— Jan 01, 2026 08:48AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 14: Surrogate Key Pipeline
Ísis Santos Costa
is on page 509 of 608
p. 475
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 13: Fact Table Builders
... ... ... ↳ Transaction Fact Table Loader
... ... ... ↳ Periodic Snapshot Fact Table Loader
... ... ... ↳ Accumulating Snapshot Fact Table Loader
— Dec 30, 2025 07:22AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 13: Fact Table Builders
... ... ... ↳ Transaction Fact Table Loader
... ... ... ↳ Periodic Snapshot Fact Table Loader
... ... ... ↳ Accumulating Snapshot Fact Table Loader
Ísis Santos Costa
is on page 507 of 608
p. 473
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 12: Special Dimensions Manager
... ... ... ↳ Date/Time Dimensions
... ... ... ↳ Junk Dimensions
... ... ... ↳ Mini-Dimensions
... ... ... ↳ Shrunken Subset Dimensions
... ... ... ↳ Small Static Dimensions
... ... ... ↳ User Maintained Dimensions
— Dec 30, 2025 07:21AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation (cont.)
... ... ↳ Subsystem 12: Special Dimensions Manager
... ... ... ↳ Date/Time Dimensions
... ... ... ↳ Junk Dimensions
... ... ... ↳ Mini-Dimensions
... ... ... ↳ Shrunken Subset Dimensions
... ... ... ↳ Small Static Dimensions
... ... ... ↳ User Maintained Dimensions
Ísis Santos Costa
is on page 504 of 608
p. 470
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation
... ... ↳ Subsystem 10: Surrogate Key Generator
... ... ↳ Subsystem 11: Hierarchy Manager
— Dec 30, 2025 07:20AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Delivering: Prepare for Presentation
... ... ↳ Subsystem 10: Surrogate Key Generator
... ... ↳ Subsystem 11: Hierarchy Manager
Ísis Santos Costa
is on page 503 of 608
p. 469
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Prepare for Presentation
... ... ↳ Subsystem 9: SCD Manager
... ... ... ↳ T1: Overwrite
... ... ... ↳ T2: Add Row
... ... ... ↳ T3: Add Column
... ... ... ↳ T4: Mini-Dimension (rapidly changing attributes from Dim)
... ... ... ↳ T5: Mini-Dimension + Type 1 Outrigger
... ... ... ↳ T6: 123
... ... ... ↳ T7: Dual 1/2
— Dec 27, 2025 03:30PM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Prepare for Presentation
... ... ↳ Subsystem 9: SCD Manager
... ... ... ↳ T1: Overwrite
... ... ... ↳ T2: Add Row
... ... ... ↳ T3: Add Column
... ... ... ↳ T4: Mini-Dimension (rapidly changing attributes from Dim)
... ... ... ↳ T5: Mini-Dimension + Type 1 Outrigger
... ... ... ↳ T6: 123
... ... ... ↳ T7: Dual 1/2
Ísis Santos Costa
is on page 497 of 608
p. 463
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Cleaning & Conforming
... ... ↳ Improving Data Quality Culture & Processes
... ... ↳ Subsystem 4: Data Cleansing System (Quality Screening & Response)
... ... ↳ Subsystem 5: Error Event Schema
... ... ↳ Subsystem 6: Audit Dimension Assembler
... ... ↳ Subsystem 7: Deduplicating System
... ... ↳ Subsystem 8: Conforming System
— Dec 27, 2025 12:27PM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Cleaning & Conforming
... ... ↳ Improving Data Quality Culture & Processes
... ... ↳ Subsystem 4: Data Cleansing System (Quality Screening & Response)
... ... ↳ Subsystem 5: Error Event Schema
... ... ↳ Subsystem 6: Audit Dimension Assembler
... ... ↳ Subsystem 7: Deduplicating System
... ... ↳ Subsystem 8: Conforming System
Ísis Santos Costa
is on page 489 of 608
p. 455
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Group 1: Extracting --> Get Data into the DW
... ↳ ... ↳ Subsystem 1: Data Profiling
... ↳ ... ↳ Subsystem 2: Change Data Capture System
+ Audit Columns
+ Timed Extracts
+ Full Diff Compare --> cyclic redundancy checksum (CRC) algorithms
+ Database Log Scraping
+ Message Queue Monitoring
... ↳ ... ↳ Subsystem 3: Extract System
— Dec 27, 2025 09:10AM
19 • ETL Subsystems and Techniques (cont.)
↳ The 34 Subsystems of ETL (cont.)
... ↳ Group 1: Extracting --> Get Data into the DW
... ↳ ... ↳ Subsystem 1: Data Profiling
... ↳ ... ↳ Subsystem 2: Change Data Capture System
+ Audit Columns
+ Timed Extracts
+ Full Diff Compare --> cyclic redundancy checksum (CRC) algorithms
+ Database Log Scraping
+ Message Queue Monitoring
... ↳ ... ↳ Subsystem 3: Extract System
