Tell us what are the different types of measures?
Submitted by: MuhammadWe have three types of measures
☛ Non- additive measures
☛ Semi-additive measures
☛ Additive measures
Non-additive measures are the ones on top of which no aggregation function can be applied. For example, a ratio or a percentage column; a flag or an indicator column present in fact table holding values like Y/N, etc. is a non-additive measure.
Submitted by: Muhammad
☛ Non- additive measures
☛ Semi-additive measures
☛ Additive measures
Non-additive measures are the ones on top of which no aggregation function can be applied. For example, a ratio or a percentage column; a flag or an indicator column present in fact table holding values like Y/N, etc. is a non-additive measure.
Submitted by: Muhammad
Read Online Data Architect Job Interview Questions And Answers
Top Data Architect Questions
| ☺ | Tell me do you know why Data Warehouse is used? |
| ☺ | Explain me what do you understand by data mart? |
| ☺ | What are conformed dimensions? |
| ☺ | Tell me what is a fact & a fact table? |
| ☺ | Tell me the physical data model? |
Top Data Structure Categories
| ☺ | Data Center Manager Interview Questions. |
| ☺ | Creative UI/UX Designers Interview Questions. |
| ☺ | Sort And Searching Interview Questions. |
| ☺ | Data Structure Linked list Interview Questions. |
| ☺ | Data Structure Arrays Interview Questions. |
