September 22, 2008 at 12:36 am
Hi All,
I have a huge cube with 10 partitions. It takes approx 20 hours to process all the partitions with 'Process Full'. I thought of going for 'Process Incremental' of the selected partitions but my source can have an updated data. So Incremental will result duplicates for the updated data. Can anyone suggest the process I can follow to handle this situation? In other words, How can I 'process update' my partitions?
September 22, 2008 at 5:13 am
Typically, updating records in fact table involves adding a reversal record for the original and then adding a new record. This way, an incremental process will cancel out the original record with the reversal. Records should have an activity date or another indicator so you are able to sum all records up to a particular point in time to see what the data looked at that point.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply