Basics - Explain ODS and ODS types.

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 103 of 110

Explain ODS and ODS types.

Total Answers and Comments: 3

Last Update: January 11, 2008 Asked by: chetan

Sponsored Links

Best Rated Answer

—

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

November 29, 2007 03:32:18

basecog

Member Since: September 2007 Contribution: 5

RE: Explain ODS and ODS types.

The ODS(Operational Data Store)Â is a subject-oriented, integrated, frequently augmented store of detailed data in the enterprise data warehouse. In ODS only reseant data will store.

Thanks & Regards
basecog

Is this answer useful? Yes | No

December 07, 2007 02:55:40

VAMSIKRISHNACH

Member Since: December 2007 Contribution: 7

RE: Explain ODS and ODS types.

OLTP Systems : Type I + ER Modelling

ODS : Type II + ER Modelling

DWH : Type II + Dimensional modelling

People use ODS as a alternative to DWH ofcourse there is a lot of difference and it doesnt support analysis on your bussiness like OLTP becasue of ER Modelling..

Is this answer useful? Yes | No

January 11, 2008 06:26:57

jaggu_mandya

Member Since: January 2008 Contribution: 9

RE: Explain ODS and ODS types.

It is designed to support Operational Monitoring. It is subject oriented,integrated database which holds the current,detailed data.
data here is volatile

Is this answer useful? Yes | No

Go To Top