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...
-
Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...
-
Extract is the first step in the ETL process which obtains data from the source systems. This is our first question. How much data we need t...
-
Measures are the values in your fact tables which provide numeric meaning to the business process event. There are three kinds of numeric me...
No comments:
Post a Comment