Daily snapshot fact table
0
votes
2
answers
512
views
I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer.
My first approach is to have a fact table with all products by client each day.
Is this the best approach?
This fact table will grow at the same rate that the products are added to costumers list.
btw i'm using Pentaho.
Asked by Ivan Pereira
(101 rep)
Nov 19, 2013, 12:30 PM
Last activity: Sep 22, 2015, 10:26 AM
Last activity: Sep 22, 2015, 10:26 AM