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 :-)
Dieter
| 
