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 |