What is the difference between operational data stage (ODS) and data warehouse?
What is the difference between operational data stage (ODS) and data warehouse?
Data warehouse
- It is a decision support database system for the purpose of organizational needs.
-It is non volatile, integrated and time variant collection of data
Operational Data Source
- It is an integrated collection of information.
-It can contain 90 days of information at maximum.
-ODS supports dynamic data.