| |
GeekInterview.com > Interview Questions > Data Warehousing > MicroStrategy
| Print | |
Question: Attributes and Facts
Answer: Explain what is the difference between a Fact and an Attribute. |
| June 06, 2009 01:56:54 |
#2 |
| ashu_eureka |
Member Since: January 2008 Total Comments: 3 |
RE: Attributes and Facts
|
Facts: You can think of facts as numerical data which can be aggregated. The facts provide insight of how the business is performing.
E.g., Sales, profit etc which are numerical and gives information about whether the business is running fine or not, are generally used as facts.
Attributes: Attributes are context which provide meaning to the numerical data (facts). In other terms they add different dimension to the data giving us complete picture of what the numerical data means.
E.g.,
If we just say Sale is 2000 than we don't get complete information about the sale.But if we say that Sale for Year 2009 is 2000 than we know more about the sale.
Similarly, Sale of Item - Book is 5000 gives meaning to the sale figure. |
| |
Back To Question | |
