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 to join 3 database like flat file, oracle, db2 in informatrica?
What is data analysis?
Explain what is data validation strategies for data mart validation after loading process?
Database in use is oracle?
What is a star schema? Why does one design this way?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
Explain swot analysis?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
What is the definition of cube in datawarehousing?
Explain how to get the first 100 rows from the flat file into the target?
Explain what is the difference between stop and abort?
Ist the schema that a data warehouse system can implements.