Warehouse Concepts Question:
Download Questions PDF

What is the difference between ODS and OLTP?

Answer:

ODS:- It is nothing but a collection of tables created in the Data warehouse that maintains only current data.

Where as OLTP maintains the data only for transactions,these are designed for recording daily operations and transactions of a business.

Download Data Warehouse Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is the difference between OLAP and datawarehosue?What is the difference between Datawarehousing and BusinessIntelligence?