Data Warehouse Schema Conventions
Use schemas to group table types
See the general conventions for a discussion about this choice
Use the following data warehouse schema objects
Schema | Contains | Reference |
---|---|---|
Dimension | Dimension Tables | |
Fact | Fact tables | |
Map | Mapping Tables | See Introducing Mapping Tables |
Etl | Tables used by the ETL loader | |
Bridge | Bridge tables (implementing M-M relations) | |
Staging | Tables staged from the source systems | |
Logs | Logs of error rows from ETL process and other logging details | |
Meta | Metadata for the warehouse |