Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11456 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathish arichandran
Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.
But it is tough to understandable since it has more tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is is a star schema?
What is a staging area? Do we need it? What is the purpose of a staging area?
How are the dimension tables designed?
What is hybrid slowly changing dimension?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what are conformed dimensions?
Explain what are the possible data marts in retail sales?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is partitioning? What are the types of partitioning?
What is Operational Data Store?
Explain the difference between data ware house & data mart?
Explain what is cost benefit analysis (cba)?
Explain dimension table ?
