What are the types of data warehousing?

i.EDW (Enterprise datawarehousing)

ü   It provides a central database for decision support throughout the enterprise

ü   It is a collection of DATAMARTS

ii.DATAMART

ü   It is a subset of Datawarehousing

ü   It is a subject oriented database which supports the needs of individuals depts. in an organizations

ü   It is called high performance query structure

ü   It supports particular line of business like sales, marketing etc..

iii.ODS (Operational data store)

ü   It is defined as an integrated view of operational database designed to support operational monitoring

ü   It is a collection of operational data sources designed to support Transaction processing

ü   Data is refreshed near real-time and used for business activity

ü   It is an intermediate between the OLTP and OLAP which helps to create an instance reports.

Thanks

Ur's Hari

If you like this post, please share it by clicking on g+1 Button.