Archives of the TeradataForum
Message Posted: Fri, 27 Jul 2012 @ 14:29:48 GMT
| Subj: || || Re: What is the difference between start/snowflake schema and Fsldm? |
| From: || || Dieter Noeth |
sughesh iyyani wrote:
| ||Kindly let me know what is the difference between start schma and Fsldm?|| |
| ||Is there any thing special for FSLDM (Financial Services Logical Data Model) compared to start schema and snowflake schema?|| |
FSLDM is a logical data model which is developed/enhanced by Teradata for lots of years (mainly 3rd normal form?).
A star or snowflake is a technique to create a data warehouse data model (denormalized) consisting of Fact and Dimension tables. It requires
less joins, but is less flexible.
| ||What is advantage of using FSLDM in financial / banking domain?|| |
FSLDM probably already covers a large percentage of the data model a bank needs, thus only some missing parts have to be implemented -> less
work for the customer.
And less work for Teradata PS, too, cause they should know how to implement their own data model :-)