Introduction to Informatica
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]
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.
Data Warehouse:-(W.H.Inmon)
A Data Warehouse is a
- time variant
- Non-volatile
- Subject oriented
- integrated Database
Ex:- Over Business Application:-
Ex:- Over sales application:-
Characteristic features of DataWarehouse:-
- Time-variant:-
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.
Non-volatile:-
- A Data Warehouse is a non-volatile
- Once the Data entered into the Data Warehouse, it doesn’t reflect the change which takes place at operational Database. Hence the Data is “static” in the Data Warehouse.
Subject Oriented:-
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.
Integrated:-
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
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
About Author
Name
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 in the market.
Stay Updated
Get stories of change makers and innovators from the startup ecosystem in your inbox