Answer Detail: What is the Difference between a ODS and Staging Area

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: What is the Difference between a ODS and Staging Area

January 01, 2009 21:31:37	#3
Vamshidhar	Member Since: February 2008 Total Comments: 4
What is the Difference between a ODS and Staging Area
ODS (Operational Data Source) is the first point in the Datawarehouse. Its store the real time data of daily transactions as the first instance of Date. Staging Area, is the later part which comes after the ODS. Here the Data is cleansed and temporarily stored before loaded into the Datawarehouse.