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



January 01, 2007 16:24:25 #5
 sindhu   Member Since: Visitor    Total Comments: N/A 
RE: what is the difference between ODS and OLTP
 

HI,

Though Both ODS and OLTP has current data, ODS may  contain normalized or Denormalized data. OLTP contains only normalized data.  ODS used for some of calculations and to get instant reports.OLTP used for only Transactional data.

Cheers
     

 

Back To Question