BI tools rollup the measures, so we keep the measures additive if possible. For example, we won't pre-calculate and keep the KPI "Unit per Transaction (UPT)" in single measure column as a ratio. Instead, we keep two measures, "Number of Units" and "Number of Transactions".
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...
-
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...
-
If we are using dimensional data model, make sure to build atomic grain base fact tables. It is true that they takes more space and performs...
-
Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...
No comments:
Post a Comment