ETL (Extract, transform, load) Question:

Download Job Interview Questions and Answers PDF

Explain Where do we use semi and non additive facts?

Extract, transform, load (ETL) Interview Question
Extract, transform, load (ETL) Interview Question

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) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What is the difference between Power Center & Power Mart?How can we determine what records to extract?