Are facts same as metrics and dimensions same as measures?
If not , please tell the difference?
Answer / rajiv
See, facts are usually metrics i.e facts can used to show
in metrics reports as they are means to measure the
data.For example:Sales revenue, profit,margin,total count
etc..
And dimensions are not measures.They are for example
objects like customer name, employee name, age, phone
number,salesid etc..
Dimensions are the means of analysis and analysis is done
on them.So they are entirely different from measures
| Is This Answer Correct ? | 6 Yes | 0 No |
Whether dimension table can have numeric value?
How many ways we test the universe & Report?
How to stop a batch?
5.Explain ODS ?
Explain what is the extension of file to save template?
Explain difference between snow flake and star schema.
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
Why is chameleon method used in data warehouse?
Describe the differences between a data warehouse and data mart.
what is indexing ? what are different types of indexes supported by oracle ?
if source contain 10records how you identify header and footer
Explain datawarehousing?