If I have a fact table at day level. I create a series of partitons on it based on month. Say, the first partition is for Jan, 2010. The second partition is for Feb, 2010 and so on. I have aggregates calculated on weekly level at each partition. If week
5 is spread over two partitions: 3 days in Jan/2010 partition and 4 days in Feb/2010 partition. Is week 5's aggregation data calculated correctly on Feb/2010 partition? In another word, will the aggregates pull the first 3 days from the Jan/2010 partition
automatically or instead week 5's aggregation is not calculated at all?
Thanks a lot.
View Complete Post