Chris Adamson’s Blog

Information for BI & Analytics Professionals

Thursday, May 12, 2011

Dates In Dimension Tables

›
A reader asks about tracking dates in the fact table vs. dimension tables. Q: It seems to me that it is sometimes more effective to store ...
Monday, April 25, 2011

Bridge Tables and Many-to-many Relationships

›
Recent posts about bridge tables generated a lot of interest. Today, I will look at the many-to-many relationships in these solutions.  Th...
Wednesday, April 6, 2011

Linking Expenditures to Commitments [Q&A]

›
A reader working on a financial data mart has a question about linking commitments (such as purchase orders) to payments: Q: Payments can...
‹
›
Home
View web version
Powered by Blogger.