Answer Detail: RE: what is the difference between ODS and OLTP

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Print |

Question: what is the difference between ODS and OLTP

July 07, 2007 15:11:53	#6
Navs	Member Since: Visitor Total Comments: N/A
RE: what is the difference between ODS and OLTP
ODS is an Operational Data System, which contains the snapshot of currently loaded data for clerical day to day analysis and includes a little history, 30-60 days of historical data in addition to the current data. OLTP is Online Transaction Processing System, which contains only the current data and keeps changing, not suitable for analysis due to temporal inconsistency unlike ODS which contains consistent data.