1.

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.

► 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.


Discussion

No Comment Found

Related InterviewSolutions