Explain ODS and ODS types.

Showing Answers 1 - 12 of 12 Answers

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

ODS is defined as subject-oriented and integrated data and volatile
repository of data.


Contains current or near to current data
could be used for day to day reporting/ low-level analysis
updatable data store
contains detail data, no summarization
data in homogeneous form.


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions