ETL (Extract, transform, load) Question:
Download Job Interview Questions and Answers PDF
Explain Where do we use semi and non additive facts?
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
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 Question | Next Question |
Explain What is the difference between Power Center & Power Mart? | How can we determine what records to extract? |