26 September, 2020
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 designed 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 an integrated Database which stores the Data in an integrated formatted; the Data is collected from multiple OLTP source systems.
If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.
A Data Warehouse is a
Ex:- Over Business Application:-
Ex:- Over sales application:-
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 known as time series analysis.
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 organize 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
Check Out Our Related Courses
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .