ETL (Extract, transform, load) Question: Download Extract, transform, load (ETL) PDF

Explain Where do we use semi and non additive facts?

Tweet Share WhatsApp

Answer:

Additve: 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

Download Extract, transform, load (ETL) PDF Read All 37 Extract, transform, load (ETL) Questions
Previous QuestionNext Question
Explain What is the difference between Power Center & Power Mart?How can we determine what records to extract?