Warehouse Concepts Question:

Download Job Interview Questions and Answers PDF

What is the difference between ODS and OLTP?

Data Warehouse Concepts Interview Question
Data Warehouse Concepts Interview Question

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?