Dimension Tables
1 dimension table names should always be in singular
2 All underscores in columns and table names should be replaced with space and type case capitalisation e.g order_id should be Order ID
3 Surrogate keys should be hidden from client tools
Dimension Tables 1 dimension table names should always be in singular 2 All underscores in columns and table names should be replaced with space and type case capitalisation e.g order_id should be Order ID 3 Surrogate keys should be hidden from client tools
Fact Tables 1 Fact table names should be plural