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 03:38:01 #3
 shobhit   Member Since: Visitor    Total Comments: N/A 

RE: what is the difference between ODS and OLTP
 

ODS :Having data with Datwarehouse that will be stand alone. No further transaction will take place for current data which is part of the data ware house. Current data will be change once you upload throgh ETL on schedule basis. 

OLTP : Having data with on line system which connected to network and all update on transaction hppened in seconds. Every second data summrasied value will get changed.

     

 

Back To Question