Reason for build Data Warehouse
- Data is scatted at different places
- Data inconsistency Once place Hyd
- Depending on volatile and non-volatile [Data keep on changing]
Desired to gain proficiency on Informatica? Explore the blog post on Informatica training to become a pro in Informatica.
Surrogate keys means artificial keys
Data Warehouse:- Ralph Kimball
A Data Warehouse is relation Database management system. which is specifically design business analyses and making decisions to archive the business goals.
A Data Warehouse is design to support decision making process hence it is called as desiccation supporting system (DSS)
A Data Warehouse is historical Database which stores historical business information required for analysis.
A Data Warehouse is a “read only Database” which supports business manages to very the Data required for analysis, but not for business transactional processing.
A Data Warehouse is a integrated Database which stores the Data in an integrated formatted, the Data is collected from multiple OLTP source systems.
A Data Warehouse is a
- time variant
- Subject oriented
- integrated Database
Ex:- Over Business Application:-
Ex:- Over sales application:-
Characteristic features of DataWarehouse:-
A DataWarehouse is a time-variant Database which supports business needs of end users in comparing and analyzing the business with different time periods. This is also knows as time series analysis.
- A Data Warehouse is a non-volatile
- once the Data entered into the Data Warehouse it doesn’t reflect to the change which takes place at operational Database. Hence the Data is “static” in the Data Warehouse.
A Data Warehouse is a subject oriented Database which supports the business need of department specific users.
Ex:- sales, accounts, hr. students, lones etc….
A subject is derived from multiple OLTP applications which organizes the Data to meet specific business functionality.
A Data Warehouse is an integrated Database which collects the Data from multiple OLTP Database
E T M (move) A Data Warehouse s container to store the business information