This is the fact table to capture stepwise (fixed steps) business processes. It captures the life cycle of a well-defined process. So, the fact table record is first inserted in the first step of the business process and is updated later after completion of the next step(s). (e.g. from ordering to shipping). Typically, there are multiple date dimension fields (e.g. ordering date and shipping date). The number of days between them could be derived as its measure (e.g. days to close).
Tuesday, October 27, 2020
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