| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: ODS and Staging
Answer: What is the difference between ODS and Staging? |
| May 05, 2009 04:47:57 |
#5 |
| prat4all |
Member Since: March 2008 Total Comments: 1 |
RE: ODS and Staging
|
| ODS keeps the transactional data from where direct reporting is possible. The data in ODS can be partly denormalized.
Staging area is the exact replica of the transactional database which acts as a source for datawarehouse processing. |
| |
Back To Question | |
