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?



June 06, 2006 11:30:29 #2
 joys   Member Since: Visitor    Total Comments: N/A 

RE: Why we can't create an aggregate on an ODS Object?...
 
The purpose of warehousing concept is to load required business data(requirements depends on endusers)in a database.Before loading data, developers has to process data which was extracted from a source systems(oltp's, file systems).ODS (operational data store) is a type of source system from which developers extract data and perfrom operations like filtering,joining ,aggregating and so on......So....ODS is a source system..and it's not possible to perform any logic on it's content as it will be in volatile in nature.So aggregation will be possible after extracting data from ODS.
     

 

Back To Question