Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain what are the different types of join operations?
How we are using this function?
What is the 4 + 1 view model as it relates to system modeling?
ware house management system is used?
What is the difference between static cache and dynamic cache?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the different types of datawarehosuing?
What is a hash cluster?
What function should we use to display the value entered or selected by a user in response to a prompt?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain what are the advantages of query studio compared to report studio?
What is degenerate dimension table?
How can we determine what records to extract?
How to performance tune reports?
