GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Concepts

 Print  |  
Question:  what is the difference between ODS and OLTP



August 08, 2006 14:51:56 #1
 mamatha   Member Since: Visitor    Total Comments: N/A 

RE: 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

     

 

Back To Question