Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 14:29:48 GMT

  <Prev Next>   <<First <Prev

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


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020