Business intelligence Question:
Why we ca not create an aggregate on an ODS Object?
Answer:
► Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.
► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.
► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.
► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.
► Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.
| Previous Question | Next Question |
| How do we Tune the BO Reports for Performance Improvement? | what is hierarchy relationship in a dimension. whether it is: 1. 1:1 2. 1:m 3. m:m |