Author Question: Conformed dimensions allow users to do the following: A) share nonkey dimension data. B) query ... (Read 33 times)

tfester

  • Hero Member
  • *****
  • Posts: 534
Conformed dimensions allow users to do the following:
 
  A) share nonkey dimension data.
  B) query across fact tables with consistency.
  C) work on facts and business subjects for which all users have the same meaning.
  D) all of the above.

Question 2

How are missing values generally handled in database management systems?
 
  What will be an ideal response?


yahahah24021

  • Sr. Member
  • ****
  • Posts: 323
Answer to Question 1

D

Answer to Question 2

When dealing with missing data, there are many options. Two integrity controls (default value and null control) will handle this problem. One also could substitute an estimate for the missing value which would then be stored in place of the missing value (and marked as an estimate). Another possible method is to use triggers to track missing values and create a log which can be viewed later. One other method is to perform sensitivity testing, which will tell us whether having missing data greatly impacts results. If results are not impacted, then the missing values are ignored.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Calcitonin is a naturally occurring hormone. In women who are at least 5 years beyond menopause, it slows bone loss and increases spinal bone density.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

For a complete list of videos, visit our video library