what is the difference between start schma and Fsldm?

Answer Posted / prabakaran

FLSDM is a 3nf model, vanilla made to cater a Bank's EDW
need.

Star Schema is a denormalized model

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is more efficient group by or distinct to find duplicates?

648


What is a dimension table?

610


What are the things to be considered while creating secondary index?

637


What type of indexing mechanism do we need to use for a typical data warehouse?

621


What is the use of fallback?

560






what is sysdba and sysdbc ? which has high priority ?

3374


In Teradata, what is the significance of UPSERT command?

597


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

691


What is bteq utility in teradata?

575


Explain Teradata performance tuning and optimization?

703


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1623


What interface is used to connect to windows based applications?

587


What is the difference between global temporary tables and volatile temporary tables?

640


How many sessions of MAX is PE capable of handling at a particular time?

599


What are the functions of a teradata dba?

600