Dataware house is a
Non-volatile: Permanent data(stores historical data or past data)
Subject-oriented: Data will be stored according to the subjects(like data-marts)
Integrated:Make a single source from heterogeneous sources
Time-variant: Data changed over a period of time
Dataware Housing: It is process of storing and retrieving data from warehouse.
Steps Involved from database to datawarehouse:
1. Extract the data from the heterogeneous sources and load into staging area(Source Dependent Loading)
2. Apply transformations on staging area and load into datawarehouse (Source Independent Loading)
3. Generate the reports from the datawarehouse by using a reporting tools like OBIEE, Cognos etc.
We can generate the reports from the OLTP or databases but the performance may decrease because the no.of joins are more.
why we do reporting?
Reporting is an essential event for analysis of the data of the specific organisation. Anyone can analyse like management, users, partners etc.We can forecast the values by using the reports or reporting tool. Reporting will be exist in all domains like Retail, Tele-communication, Insurance, Banking, Education, Public sector industries or factories and private sector industries.Analysis of data is everywhere like small-scale, medium-scale and large-scale industries.
No comments:
Post a Comment
Do you want to comment