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'
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'
Submitted by: Administrator
Read Online Oracle ETL Job Interview Questions And Answers
Top Oracle ETL Questions
☺ | What are the various methods of getting incremental records or delta records from the source systems? |
☺ | What is partitioning? What are the types of partitioning? |
☺ | Where do we use connected and un connected lookups? |
☺ | What are snapshots? What are materialized views & where do we use them? What is a materialized view log? |
☺ | Compare ETL & Manual development? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |