4.Explain Snowflkeschema ?
Answer Posted / samir kumar sahoo
In snowflake schema the dimension table(denormalized table)
will be further divided into one or more dimentions
(normalized tables) to organize the infomation in a better
structural format.To design snowflake we should first
design star schema design.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between e-r modeling and dimentional modeling?
Explain can report net connect multiple datasource at a time in report creation time?
How to handle multi value dimensions?
What are the steps involved in designing a fact table?
What is dimensional modelling?
Explain when do we analyze the tables? How do we do it?
Why fact table is in a normal form?
What is many-to-many dimensional model in datawarehousing ?
Name a few sectors which use data warehousing?
What are the design methods of data warehousing?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Explain what is analytical or analytic mean?
what is parallel query?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is called dimensional modelling?