Answer Posted / swamy.l.n
1.IN A STAR SCHEMA IF A DENORMALIZE DIMENTION TABLE SPLITED
INTO ONE OR MORE DIMENTION TABLE RESULTS IN THE
NORMALIZATION OF DIMMENTION TABLE.
2.SINCE THE D-BASE DESIGN LOOKS LIKE A SNOW FLAKE
STRUCTURE.IT IS KNOWN AS SNOW-FLAKE(OR)STAR-FLAKE.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
For faster process, what we will do with the universe?
Explain a relation schema and a relation?
Store (and count) non-fact records?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain why fact table is in normal form?
Where the cache files stored?
What is Cognos script editor?
What is the difference between view filter and report filter?
Explain what is the difference between power center & power mart?
What is data stream and data adaopter. Is it same are different? Explain?
What are the different types of join operations?
What are the design methods of data warehousing?
How can we run the graph? What is the procedure for that?
How to create different types of templates?
