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
How to Extract data from multiple legacy systems?
What are the various indexes in teradata? Why are they preferred?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What are the functions of a teradata dba?
What is TPD?
What are the different functions performed in development phase?
Difference between multiload and tpump?
Define views in teradata with syntax.
Discuss the advantages of using partitioned primary index in a query?
Explain Teradata performance tuning and optimization?
What is primary index and secondary index?
What are the steps involved after the disk manager passes the request?
Explain parsing engine in teradata?
What is the difference between union and union all in teradata?
What are the different methods ot loading a dimension table? A fact table etc?