GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Intelligence

 Print  |  
Question:  Why we can't create an aggregate on an ODS Object?



March 03, 2006 09:22:40 #1
 Shadrach Rathinaraj Database Expert  Member Since: December 2005    Total Comments: 3 

RE: Why we can't create an aggregate on an ODS Object?...
 

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

2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.

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

     

 

Back To Question