Question

Which (choose ONLY one) of the following statements is/are true about Granularity Mismatch (GM): GM is...

  1. Which (choose ONLY one) of the following statements is/are true about Granularity Mismatch (GM):
  1. GM is caused by snow flaking (normalizing the Dimension tables)
  2. best practices say we should try to handle GM by considering the Allocation technique
  3. GM means the grain of one of the DIMs does not match the grain of the cube

       4. best practices say we should try to handle GM by creating a Degenerate Dimension

Homework Answers

Answer #1

Answer : The correct statement about Granularity Mismatch is 1 : GM is caused by snow flaking(normalizing the dimension tables).

Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle. The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.

The primary disadvantage of the snowflake schema is that the additional levels of attribute normalization adds complexity to source query joins.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Which (choose ONLY one) of the following statements is/are true about dimension hierarchies (HIERs): MBR Names...
Which (choose ONLY one) of the following statements is/are true about dimension hierarchies (HIERs): MBR Names are always unique within their level MBR Names are always unique within their hierarchy MBR Keys are always unique within their level MBR Keys are always unique within their hierarchy all of the above are true
Which (choose ONLY one) of the following statements is/are true about a FACT in an MDM:...
Which (choose ONLY one) of the following statements is/are true about a FACT in an MDM: it is typically something we want to analyze "numerically" in OLAP it is often numeric, but can be textual it is impossible for its value to be "known / knowable ahead of time" (e.g. it cannot be selected from a finite list of known values) both a and b are true both a and c are true none of the above are true
Which (choose ONLY one) of the following statements is/are true about Dimension Hierarchies (HIERs), Levels (LVLs),...
Which (choose ONLY one) of the following statements is/are true about Dimension Hierarchies (HIERs), Levels (LVLs), and Members (MBRs) in an MDM: For each LVL in the HIER, the number of MBRs in that level must be less than the number of MBRs in this LVL's parent LVL For each LVL in the HIER, the number unique values for any DATT in that level cannot be greater than the number of MBRs in that level For each LVL in the...
Which (choose ONLY one) of the following statements is/are true about Inmon's DWE with DW 1.0:...
Which (choose ONLY one) of the following statements is/are true about Inmon's DWE with DW 1.0: everything in the data warehouse(s) and everything in the data mart(s) is usually stored in third normal form (3NF) everything in the data warehouse(s) and everything in the data mart(s) is usually stored completely denormalized everything in the data warehouse(s) is usually stored in third normal form (3NF) and everything in the data mart(s) is usually stored completely denormalized everything in the data warehouse(s)...
9. Which of the following is not true about the virtues in Aristotle’s ethics? (a) They...
9. Which of the following is not true about the virtues in Aristotle’s ethics? (a) They are states of character. (b) The virtuous person experiences pleasure when doing virtuous actions. (c) They are acquired via divine commands. (d) They allow our characteristic activities to be performed well. (e) They require our sentiment as well as our intellect.                                                                                                 10. Which of the following best captures the conclusion of Nagel’s argument in “What Is It Like to be a Bat?” (a)...
The following paragraphs describe a series of hypothetical experiments, each of which involves one or more...
The following paragraphs describe a series of hypothetical experiments, each of which involves one or more design flaws. Please read the paragraphs and match them to what went wrong. options are: demand characteristics, missing a control group, extraneous variable(s) present, placebo effect A group of psychologists wants to determine whether scream therapy actually helps people feel better. To test this, they recruit a number of subjects who have recently complained of extreme nervousness, and they carefully measure their anxiety using...
Consumerization of Technology at IFG3 “There’s good news and bad news,” Josh Novak reported to the...
Consumerization of Technology at IFG3 “There’s good news and bad news,” Josh Novak reported to the assembled IT management team at their monthly status meeting. “The good news is that our social media traffic is up 3000% in the past two years. Our new interactive website, Facebook presence, and our U-Tube and couponing promotions have been highly successful in driving awareness of our ‘Nature’s Glow’ brand and are very popular with our target demographic—the under-30s. Unfortunately, the bad news is...
Please review the following below and provide , one-page reaction to this budget proposal. 1. Budget...
Please review the following below and provide , one-page reaction to this budget proposal. 1. Budget The President’s Budget and Health Care While the president’s budget is not likely to be acted upon by Congress, it does signal what the administration’s priorities are—as well as what policy initiatives they might push. Repeal the Affordable Care Act: The administration’s budget includes a plan that is based upon the plan put forward by Sens. Lindsey Graham (R-SC) and Bill Cassidy (R-LA) last...
Team 5 answer the questions What are 4 key things you learned about the topic from...
Team 5 answer the questions What are 4 key things you learned about the topic from reading their paper? How does the topic relate to you and your current or past job? Critique the paper in terms of the organization and quality. Incentive Systems             In this paper, we will focus primarily on financial rewards that companies use to attract, retain and motivate the brightest and most talented candidates in the labor market. By providing a reward system that...
      MK Restaurant: Branding of Thai-Style Hotpot The restaurant industry is one of the most...
      MK Restaurant: Branding of Thai-Style Hotpot The restaurant industry is one of the most competitive in Thailand. With a large number of players ranging from restaurants in five-star hotels, global fast-food chains to small stalls along the streets and everything in between, the Thais are spoiled for choice. In addition, as the world becomes globalized, consumers are familiar with international dishes and would not hesitate to try new offerings from the other side of the globe. As a...