It is central data repository where data is stored from one or more heterogeneous data sources.Ī DW system stores both current and historical data. It may pass through operational data store or other transformations before it is loaded to the DW system for information processing. The data in DW system is loaded from an operational transaction system like Sales, Marketing, HR, SCM, etc. The data in DW system is used for Analytical reporting, which is later used by Business Analysts, Sales Managers or Knowledge workers for decision-making. Data warehouse is used for reporting and analyzing of information and stores both historical and current data. A Data warehouse is known as a central repository to store the data from one or multiple heterogeneous data sources.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |