O'Reilly logo
  • Jaime Montoya thinks this is interesting:

14.  Place each dimension into its own dimension table, as shown in Figure 6-15. Include a table name beginning with “Dim” and a primary key designation in each table.
Figure 6-14   The Manufacturing data mart schema with measures in a fact table


I added "Fact" as the suffix of fact tables and "Dim" as the prefix of dimension tables. Now it is easy to differentiate fact and dimension tables in my data mart simply by reading the table names.