Need help on
how teradata will support for 3rd normal form and dimentional modeling(star & snowflake schema).
and what is the difference between 3 NF and dimentional modeling?
To keep it simple:Dimension modelling is intended for more select operations, hence redundancy is allowed and need not be normalised
Where as OLTP systems are intended for faster insert/updates hence to avoid redundancy they need to be under 3NF
This page on my Database Answers Web Site discusses different types of Data Models and shows examples of 3rd Normal Form and Dimensional Models :-
The 3NF follows the original rules of Ted Codd, which are summarised on this page :-
One benefit of following the Teradata Best Practice of having 3NF Data Warehouse is that it helps to guarantee a 'Single View of the Truth'.
On the other hand, a Dimension Model, whether star or snowflake, is designed with Dimensions and Facts.
Dimensions are things like Time Periods, Locations and Products.
Facts are totals, averages, percentages and so on.
Database Answers Ltd.
Hi, take a llok at this post, maybe it helps