Friday, 31 August 2012

Differences between Datawarehouse schema and RDBMS schema?


RDBMS Schema
DWH Schema
Used in OLTP system like banking
Used for OLAP systems
Its Normalized using either of the normal forms
Its De normalized
Its difficult to understand the tables and understand in User perspective
Easy to understand and mainly used for data analysis and extracting the data.

2 comments:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM COGNOS VARICENT, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on IBM COGNOS VARICENT. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis