Advanced dimensional modeling Part II - VIDEOCONFERENCE
21 Abril 2020, 13:00 • André Osório e Cruz de Azerêdo Falcão
Dimensional modeling–Bridge hierarchies and tables
Multivalued dimensions
Types of fact tables
Modeling recommendations: Rules to follow, Mistakes to avoid
Data warehouse loading: Responsibilities of the ETL system; Detection of data changes;Data quality tests–Maintenance of surrogate keys