January 28, 2014 at 9:57 am
Hi All,
We need process a cube dimensions incrementally. Only for first load of the dimension table all the dimensions in the cube need to be processed after that when ever incremental load is happening in the dimension table only those rows in the cube need to be processed. Also, when some rows in the dimension table is updated only those rows in the cube need to be processed.
By doing this, we can avoid processing the complete table again and again. Please suggest how this can be taken care. Thanks.
Regards
Jim
January 28, 2014 at 12:51 pm
Jim1234 (1/28/2014)
Hi All,We need process a cube dimensions incrementally. Only for first load of the dimension table all the dimensions in the cube need to be processed after that when ever incremental load is happening in the dimension table only those rows in the cube need to be processed. Also, when some rows in the dimension table is updated only those rows in the cube need to be processed.
By doing this, we can avoid processing the complete table again and again. Please suggest how this can be taken care. Thanks.
Regards
Jim
Use "PROCESS UPDATE" as opposed to "PROCESS FULL" to achieve exactly what you've asked.
January 29, 2014 at 10:37 am
Agree....just remember a few things:
1. Make sure your dimension columns being updated have been defined as Flexible.
2. You may be surprised at how much time this may take as any cube aggregations or calculations depending on these columns will be rebuilt. This can be mitigated to some extent with other setting adjustments.
3. You will probably want to do a process full to your cube every now and then as incremental proccessing can cause fragmentation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply