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