Business Intelligence - Why we can't create an aggregate on an ODS Object?

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

Go To First | Previous Question | Next Question

Business Intelligence | Question 12 of 39

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

Total Answers and Comments: 4

Last Update: January 10, 2008 Asked by: VenkateshVandanapu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 16, 2006 09:22:40

joinKishore

Member Since: December 2005 Contribution: 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.

Is this answer useful? Yes | No

June 02, 2006 11:30:29

joys

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.

Is this answer useful? Yes | No

May 02, 2007 22:40:21

Javid

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

Hi,

This is a common question, asked anywhere.

While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS (operational Data Store) and from there, using an ETL tool, and depends upon the business logic we load the datawarehouse, which has historical data.

Aggregate table is like a FACT table in a star schema and it requires a proper Modelling of data, that we cant find in the ODS part.

Thanks
Javid

Is this answer useful? Yes | No

January 10, 2008 15:20:28

sithu

Member Since: March 2006 Contribution: 46

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

ODS Data will be keep on changing...that only we are unable to do

Cheers, Sithu

Is this answer useful? Yes | No

Go To Top