DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

What is the difference between ODS and OLTP?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is the difference between ODS and OLTP?

ODS:- It is nothing but a collection of tables created in the Datawarehouse 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

(Continued on next question...)

Other Job Interview Questions