Explain What are non-additive facts in detail?
Submitted by: AdministratorA fact may be measure, metric or a dollar value. Measure and metric are non additive facts.
Dollar value is additive fact. If we want to find out the amount for a particular place for a particular period of time, we can add the dollar amounts and come up with the total amount.
A non additive fact, for eg measure height(s) for 'citizens by geographical location' , when we rollup 'city' data to 'state' level data we should not add heights of the citizens rather we may want to use it to derive 'count'
which cant be summed up with any columns in the table(all dimension keys)
EX: ratio columns,profit margin
Submitted by: Administrator
Dollar value is additive fact. If we want to find out the amount for a particular place for a particular period of time, we can add the dollar amounts and come up with the total amount.
A non additive fact, for eg measure height(s) for 'citizens by geographical location' , when we rollup 'city' data to 'state' level data we should not add heights of the citizens rather we may want to use it to derive 'count'
which cant be summed up with any columns in the table(all dimension keys)
EX: ratio columns,profit margin
Submitted by: Administrator
Read Online Warehouse Concepts Job Interview Questions And Answers
Top Warehouse Concepts Questions
☺ | What is the difference between ODS and OLTP? |
☺ | Explain Is OLAP databases are called decision support system true/false? |
☺ | Explain What are non-additive facts in detail? |
☺ | Explain What is the difference between OLAP and datawarehosue? |
☺ | What is cubes? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |