Why we ca not create an aggregate on an ODS Object?
Submitted by: Administrator► 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.
Submitted by: Administrator
► 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.
Submitted by: Administrator
Read Online Business intelligence Job Interview Questions And Answers
Top Business intelligence Questions
| ☺ | What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with Examples? |
| ☺ | What is OLAP in Business Intelligence? |
| ☺ | What is Business Intelligence? |
| ☺ | What is the purpose of reporting? |
| ☺ | Why we ca not create an aggregate on an ODS Object? |
Top Basic Job Categories
| ☺ | Targeted Selection Interview Questions. |
| ☺ | Business intelligence Interview Questions. |
| ☺ | Puzzles Interview Questions. |
| ☺ | Behavioral Interview Questions. |
| ☺ | Freshers Graduate Interview Questions. |
