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
- Chapter 6. Building Foundations—Creating Data Marts
- from Delivering Business Intelligence with Microsoft® SQL Server® 2012, Third Edition
- Publisher: McGraw-Hill
- Released: March 2012
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.
Share this highlighthttp://learning.oreilly.com/a/delivering-business-intelligence/21383448/