Measurements in a fact table that can be summed up across all dimensions
Consider the following retail fact table:
Relateed
[Related Article: Trending Data Warehouse Tools]
Measurements in a fact table that can be summed up across only a few dimensions keys Following table is used to record current balance and profit margin for each id at a particular instance of time (Day end)
In the above table, we cannot sum up current balance across Acct Id
If we ask balance for Id 21653 we will say that 22000, not 22000+80000
Checkout Informatica Interview Questions
Facts that cannot be summed up across any dimension key
Note: % and ratio columns are non-addictive facts
Related Blog: Snowflake vs Redshift
A fact table without any measures is called the factless fact table
It contains only keys
It acts as a bridge between dimension keys
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
Snowflake Training | Apr 20 to May 05 | View Details |
Snowflake Training | Apr 23 to May 08 | View Details |
Snowflake Training | Apr 27 to May 12 | View Details |
Snowflake Training | Apr 30 to May 15 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.
1 / 10
Copyright © 2013 - 2024 MindMajix Technologies