Warehouse Concepts Question: Download Data Warehouse Concepts PDF

What is the difference between ODS and OLTP?

Tweet Share WhatsApp

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 PDF 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?