Where do we use semi and non additive facts?
Submitted by: AdministratorAdditve: A masure can participate arithmatic calulatons using all or any demensions.
Ex: Sales profit
Semi additive: A masure can participate arithmatic calulatons using some demensions.
Ex: Sales amount
Non Additve:A masure can't participate arithmatic calulatons using demensions.
Ex: temparature
Submitted by: Administrator
Ex: Sales profit
Semi additive: A masure can participate arithmatic calulatons using some demensions.
Ex: Sales amount
Non Additve:A masure can't participate arithmatic calulatons using demensions.
Ex: temparature
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. |
| ☺ | Oracle RMAN Interview Questions. |
