We need to understand the business processes and ask the right questions. Some managers will ask for whatever information they can get without thinking carefully about what they really need. Too much information can be as harmful as too little. Other managers may omit things they ought to know, or they may not know to ask for some types of information they should have.
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...
-
Factless fact table is the fact table which log an business event but does not contain any measure fields. Typical use cases are the attenda...
-
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...
-
Transactional Fact and Snapshot Fact tables are usually designed from the corresponding individual business process. Consolidated Fact table...
No comments:
Post a Comment