Business intelligence Question:
Download Job Interview Questions and Answers PDF
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.
Download Business intelligence Interview Questions And Answers
PDF
| 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 |