I needed to provide drill down to some granular attributes, so I setup a degenerate dimension with several attributes like serial_number, etc. Doing so has somewhat understandably caused my processing time to increase from 2 minutes to 45 minutes for my sample set of data.
To handle this increased processing time, I'm attempting to use partitioning. Now, the trouble I'm running into is how do I process the degenerate dimension in step with the partitions. I am getting errors from the process that boil down to fact_key does not exist in the degenerate dimension so the fact can not be joined to the fact dimension table. How do I process a degenerate dimension in step with my partitions. Does that make sense?
Keehan
Try to see where most of the time of your processing goes. Try to process dimensions and partitions separately.
Is processing partitions becomes way slower? Or it is dimension processing that takes most of the time?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
The same question.
If we use 12 partitions, and set 12 fact table to them, how about the fact dimention? it will get new members from diffrent fact tables by itself correctly?
No comments:
Post a Comment