| |
GeekInterview.com > Interview Questions > Data Warehousing > Concepts
| Print | |
Question: what is the difference between ODS and OLTP
|
| May 05, 2008 04:52:01 |
#7 |
| njvijay |
Member Since: May 2007 Total Comments: 10 |
RE: what is the difference between ODS and OLTP
|
1. ODS - It is a decision support system which contains snapshot of current data for day to day analysis. This may include little history data also
OLTP - It is a trasaction system though it contains current data it keeps changing due to lot of transaction. This does not have history data
2. ODS - It is data integrated, subject oriented, time variant and non volatile enterprise wide data for analysis
OLTP - It is just transactional to support particular business process. It is not data integrated on different business process across organization
3. ODS - Denormalized data may contain normalized data also
OLTP - Highly Normalized to reduce data redunduncy |
| |
Back To Question | |
