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:  what is the definition of normalized and denormalized view and what are the differences between them



August 08, 2006 08:02:56 #5
 Sphurti   Member Since: Visitor    Total Comments: N/A 

RE: what is the definition of normalized and denormali...
 

I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and foreign key data needs to be fetched from its respective Master tables. Whereas in OLAP, as the data is in De-normailzed form, for a query the no. of tables queried are less.

For eq.:- If we have a banking appln., in OLTP env., we will have a separate table for customer personal details , Address details, its transaction details etc..Whereas in OLAP env. these all details can be stored in one sinlge table thus decreasing the scanning of multiple tables for a single record of a customer details.

     

 

Back To Question