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 |
Explain what are the mapping paramaters and maping variables?
Which is the optimized method of extracting the data.
Explain what is the difference between datawarehouse and bi?
Explain what are the tasks that loadmanger process will do?
difference between For each and for all
Explain what is full load & incremental or refresh load?
Explain differences between star and snowflake schemas?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Explain the difference between oltp and olap?
Explain difference between snow flake and star schema.
What is the limit to the number of sources and targets you can have in a mapping?
Best Data Ware housing training institute in delhi