Answer Detail: RE: ODS and Staging

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: ODS and Staging

Answer: What is the difference between ODS and Staging?

October 10, 2008 06:41:24	#3
sagarikaka	Member Since: April 2008 Total Comments: 7
RE: ODS and Staging
Data Staging is also called 'Operational Data Store'(ODS). It is a data holding place where the data which is extracted from all the data sources are stored. From the staging area the data is loaded to DWH. Data cleansing takes place in this stage.