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.
Where as OLTP maintains the data only for transactions,these are designed for recording daily operations and transactions of a business.
Previous Question | Next Question |
Explain What is the difference between OLAP and datawarehosue? | What is the difference between Datawarehousing and BusinessIntelligence? |