Ísis Santos Costa’s Reviews > The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling > Status Update

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

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

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

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

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

p. 450
19 • ETL Subsystems and Techniques
↳ Round Up the Requirements
... ↳ Biz Needs
... ↳ Compliance
... ↳ Data Quality
... ↳ Security
... ↳ Data Integration
... ↳ Data Latency
... ↳ Archiving and Lineage
... ↳ BI Delivery Interfaces
... ↳ Available Skills
... ↳ Legacy Systems
↳ The 34 Subsystems of ETL
... ↳ Group 1: Extracting
... ↳ Group 2: Cleaning & Conforming
... ↳ Group 3: Delivering
... ↳ Group 4: Managing

p. 442
18 • Dimensional Modeling Process and Tasks (cont.)
↳ Design the Dimensional Model (cont.)
... ↳ Review and Validate the Model
... ... ↳ IT Reviews
... ... ↳ Core User Review
... ... ↳ Broader Business User Review
... ↳ Finalize the Design Documentation

p. 439
18 • Dimensional Modeling Process and Tasks (cont.)
↳ Design the Dimensional Model
... ↳ Reach Consensus on High-Level Bubble Chart
... ↳ Develop the Detailed Dimensional Model
... ... ↳ Identify Dims & their Attributes
... ... ↳ Identify the Facts
... ... ↳ Identify Slowly Changing Dimension Techniques
... ... ↳ Document the Detailed Table Designs
... ... ↳ Track Model Issues
... ... ↳ Maintain Updated Matrix

p. 434
Dimensional Modeling Process and Tasks
↳ Modeling Process Overview
↳ Get Organized
... ↳ Identify Participants, Especially Business Representatives
... ↳ Review the Business Requirements
... ↳ Leverage a Modeling Tool
... ↳ Leverage a Data Profiling Tool
... ↳ Leverage or Establish a Naming Convention
... ↳ Coordinate Calendars and Facilities

p. 428
Kimball DW/BI Lifecycle Overview
↳ Common Pitfalls Auto Avoid
...↳ 6 Make back room performance > ease of use
...↳ 7 Invest time in normalizing instead of building dimensional models
...↳ 8 Galactic multi-year project
...↳ 9 Lack a business senior management visionary as business sponsor
...↳ 10 Love tech & data instead of business' requirements and goals