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  >  Basics

 Print  |  
Question:  Explain ODS and ODS types.



December 12, 2007 02:55:40 #2
 VAMSIKRISHNACH   Member Since: December 2007    Total Comments: 7 

RE: Explain ODS and ODS types.
 

OLTP Systems : Type I + ER Modelling

ODS : Type II + ER Modelling

DWH : Type II + Dimensional modelling

People use ODS as a alternative to DWH ofcourse there is a lot of difference and it doesnt support analysis on your bussiness like OLTP becasue of ER Modelling..

     

 

Back To Question