Author Question: Conformed dimensions allow users to do the following: A) share nonkey dimension data. B) query ... (Read 34 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?

Liver spots have nothing whatsoever to do with the liver. They are a type of freckles commonly seen in older adults who have been out in the sun without sufficient sunscreen.

Did you know?

Acetaminophen (Tylenol) in overdose can seriously damage the liver. It should never be taken by people who use alcohol heavily; it can result in severe liver damage and even a condition requiring a liver transplant.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

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?

More than 150,000 Americans killed by cardiovascular disease are younger than the age of 65 years.

For a complete list of videos, visit our video library