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
Highlight a few of the important components of Teradata?
Define views in teradata with general syntax.
What are the primary characteristics of the Teradata.
What is the difference between union and union all in teradata?
What is stored procedure in teradata?
What do you mean by parsing?
Highlight all the modes that are present under Confidence Level.
What exactly do you know about catching in teradata?
How will you solve the problem that occurs during update?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
How do you do backup and recovery in teradata?
What do you mean by tpt in teradata?
Explain teradata architecture in detail with a diagram.
What are default access rights in teradata?