what is the difference between start schma and Fsldm?
- 5 Answers
- 47437 Views
- Intel, I also Faced
- E-Mail Answers
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 do you define Teradata?
Explain the meaning of Amp?
How do you verify a complicated sql?
Explain the parallel data extension in teradata?
How do you determine the number of sessions?
Explain PDE.
Can you fastexport a field, which is primary key by putting equality on that key?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the functions performed by bynet?
What are the string manipulation operators and functions associated with teradata?
Difference between stored procedure and macro?
What are default access rights in teradata? What explicit right can be given to a user?
Why does varchar occupy 2 extra bytes?
Explain the types of join supports by teradata?
What are some primary characteristics of teradata?
