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
Posts
Comments
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a...
-
Define what a Loop is Detect and recognize loops in Universe Using Aliases and Contexts to resolve the loops Identify when in the design ... -
Introduction to Semantic Layers The semantic layer is a metadata layer that abstracts the complexities of the data source. The end user see...
0 comments:
Post a Comment