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...
-
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