Data Warehouse Prerequisites. Familiarity with Microsoft SQL Server System Administration for Microsoft SQL Server 7.0 and Implementing a Database on Microsoft SQL Server 7.0 Knowledge of Transact-SQL Usage in Developing OLTP Systems
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Special Thanks to Bill Inmon, the “grandfather”
of data warehousing.
A data warehouse is a:
collection of data in support of management's decision making process.
Current valued data
Time horizon: 60 – 90 days
Key fields may or may not have an element of time
Data can be updated
Time horizon: 5 – 10 days
Keys do not have an element of time
Once snapshot is made, records cannot be updatedTime Variant
The different components of the data warehouse are:
collection of data in support of management's decision needs.
lightly summarized data, and
highly summarized data.