ODS Vs. Data Warehouse
Operational Data store
- Data Focused Integration From Transaction Processing Focused Systems
- Age Of The Data is Current, Near Term (Today, Last Week’s)
- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational
Results
- Frequency Of Load: Twice Daily , Daily, Weekly
Datawarehouse
- Subject Oriented,Integrated,Non-Volatile,Time Variant
- Age of the Data is Historic (Last Month, Qtrly, Five Years)
- Primary Use: Long-Term Decisions Strategic Reporting Trend Detection
- Frequency of load : Weekly, Monthly, Quarterly
Subscribe to:
Post Comments (Atom)
Posts
2 comments:
This is very very good blog with good and important contain.Many thanks to mareshwar.Me gaining a lot of knowledge from this.
Post a Comment