Data Warehouse is repository of Data picked from Transaction systems, and filtered and transformed to make it available for data analysis reporting.
Data-Warehouse is a repository of Data, which can provide most OR all of the Data and information requirements of an enterprise. It means that it pulls data from all the production and other sources. Once the data is pulled onto an offline staging area, it is cleansed, transformed and loaded into a sanitized, uniform and well-organized manner so that you can run queries, reports and all kind of analysis on the data.
There are a number of important tools which are connected to data warehouses, and one of these is data aggregation.Data warehousing requires a hardware platform, database, data loading method (ETL tools), and data extract method (reporting and business intelligence tools). Informatica is a famous ETL tool and Buisness Object is a reporting tool..
Subscribe to:
Post Comments (Atom)
-
Common BI queries Relational queries Vs OLAP queries Before moving to terms used in Data warehouse, let us see the architect... -
From yesterday onwards, I am stuck up with an error while trying to deploy cube. " You cannot deploy the model because the localhost ...
-
CRM Involves managing all aspects of a customer’s relationship with an organization to increase customer loyalty and retention and an organ...
No comments:
Post a Comment