Warehouse Concepts Question:

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.

Read All 16 Data Warehouse Concepts Questions
Previous QuestionNext Question
Explain What is the difference between OLAP and datawarehosue?What is the difference between Datawarehousing and BusinessIntelligence?