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

SchemaContainsReference
DimensionDimension Tables
FactFact tables
MapMapping TablesSee Introducing Mapping Tables
EtlTables used by the ETL loader
BridgeBridge tables (implementing M-M relations)
StagingTables staged from the source systems
LogsLogs of error rows from ETL process and other logging details
MetaMetadata for the warehouse