Tuesday, September 15, 2020

BI/DW Best Practice #9 - Contain date dimension in all fact tables

If we are using dimensional data model, make sure to include a date dimension (at least one) in every fact tables. It must be an item in our checklist for our dimensional model design. I can't imagine if we can miss the date in any business activities. 

at
Labels: , ,
Location: 加拿大艾伯塔卡加利

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Extract: Performance Tips

Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...

  • What is Fact Table?
    Fact table stores the measures of the business process event and associates them with the descriptive context (dimension tables). So, there ...
  • Constraints and indexes of Fact and Dimension Table
    We usually implement the multi-dimensional data model in RDBMS or CUBE. Today, we focus on the Constraints and indexes in multi-dimensional ...
  • Transfer extracted data and checking
    As mentioned in previous post, pushing or the publish/subscribe model are preferred. Todays topic is how to transfer the extracted files.