what is the difference between start schma and Fsldm?
Answer Posted / vinay sir(datawarehousing tech
Adding more to the above:
FSLDM->It was designed with variuos Subject Areas
(PARTY,LOCATION,ADDRESS,EVENT etc...).Each Subject Area is
again made up of different Entities and all these entities
are fully normalized.
Simply FSLDM consists of Many Entities and the structure
is in 3NF.
Star Schema: This can also be called as Star Join Schema.
Star schema consists of Less Entities(Fewer Fact and
Dimension tables--preferrably one fact with many dimensions)
and the structure is Denormalized.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Did you write stored procedures in teradata?
What is inner join and outer join?
Explain fastload in teradata?
How many codd's rules are satisfied by teradata database?
What is the purpose of using case expression in teradata?
How to view every column and the columns contained in indexes in teradata?
What are the 5 phases in a multiload utility?
Explain and compare pros and cons of start schemas?
Why is the case expression used in teradata?
How do you define Teradata?
What is the purpose of upsert command?
Explain how spool space is used.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Can you connect multiload from ab initio?
Highlight the limitations of TPUMP Utility.