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 is MLOAD Client System restarted after execution?
What are teradata utilities?
What is teradata and why it is used?
What are the things to be considered while creating secondary index?
Explain parsing engine in teradata?
What is bteq script in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Why managing the data is important?
In Teradata, how do we Generate Sequence?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Steps to create a data model?
How can bottlenecks be identified?
Highlight the limitations of TPUMP Utility.
Difference between stored procedure and macro?