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.
|
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Friday 31 August 2012
Differences between Datawarehouse schema and RDBMS schema?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment