|
Data Warehouse loaded area should be the first choice. Sometimes the transaction reports need information, which does not exist in loaded area, as it is not important for analysis (for example detailed address). In that case on might think of using a staging database.
As a principle however, we recommend to use only data warehouse for your enterprise reporting. Using a staging area complicates and muddies the operations. Staging area is the processing are for making the information ready for data warehouse (loaded area). By getting enterprise reporting from staging areas as well, one has to put additional checks, and also has to make sure that no further transformation or changes are happening on that data before it is loaded. If that is not the case you may have a mis-match between staging-area based reporting and Data Warehouse based reporting. |
