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.
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...
-
We usually implement the multi-dimensional data model in RDBMS or CUBE. Today, we focus on the Constraints and indexes in multi-dimensional ...
-
The data warehouse / data mart are usually implemented in RDBMS. RDBMS provides lots of features to manage data which are useful for both op...
-
In traditional data modeling, we usually add "created date", "last modified date", "created by" and "last...
No comments:
Post a Comment