Answer Detail: RE: What is the Difference between a ODS and Staging A...

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

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

August 08, 2007 04:33:42	#2
siraj khan	Member Since: Visitor Total Comments: N/A
RE: What is the Difference between a ODS and Staging A...
The full form of ODS is Operational Data Store.ODS is a layer between the source and target databases..ODS is used to store the recent data. Staging layer is also a layer between the source and target databases..Staging layer is used for cleansing purpose and store the data periodically.