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
How to provide security in frame work manager for a query subject?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
What is latest version of power center / power mart?
What is many-to-many dimensional model in datawarehousing ?
Explain what is a cube in data warehousing concept?
Explain what are the different methods of loading dimension tables?
What is VLDB?
What are aggregate transformation?
How to test report in reportnet?
Explain me what is vldb?
How to export mappings to the production environment?
What is a data profile?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Database in use is oracle?
Explain hybrid slowly changing dimension?