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
Describe the set operators in teradata.
How do you define Teradata?
What is the function of parser component in teradata?
Explain fallback in teradata?
What is primary index and secondary index?
Highlight the need for Performance Tuning.
What are the different table types that are supported by teradata?
What are the multiload utility limitations?
What are the uses of bynets in multi-node systems?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the advantages of teradata?
What is the difference between teradata and oracle?
What is node? How many nodes and amps used in your previous project?
What is difference between user and database in teradata?
What does sleep function does in fast load?