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 |
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
How to calculate fact table granularity?
What is analytical or analytic mean?
Can we have multiple application.cfm file in an application?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
What are data validation strategies for data mart validation after loading process?
Explain what is batch and describe about types of batches?
Explain difference between e-r modeling and dimentional modeling?
Explain how to get the first 100 rows from the flat file into the target?
Why is chameleon method used in data warehouse?
How can we transform row to column?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends