Explain 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 ETL (Extract, transform, load) Job Interview Questions And Answers
Top ETL (Extract, transform, load) Questions
| ☺ | Explain What is ETL process ?How many steps ETL contains explain with example? |
| ☺ | How to calculate fact table granularity? |
| ☺ | Explain What is Full load & Incremental or Refresh load? |
| ☺ | Explain the difference between etl tool and olap tools? |
| ☺ | Explain What are the different versions of Informatica? |
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. |
