Incremental Cube

[2ray]

Here is the problem that we have.

We want to do incremental all week and then on the weekend do a full build.

We use a different model for the incremental build.

The first incremental that we do after the full build fails on an invalid error because the cube was not built with the incremental model.

Would anyone have a way to run a script after the full build that would validate the cube with the incremental model ?


Thanks, Ray

 

[2ray]

Let me clarify we use the same model but with different attributes.

 

[ibmdb2]

Just want to confirm a few things.You are building it using a Increemental model on the weekdays and then at the end of the week you pull the entire data using adifferent model and now you wanna use this model for the increemental update.Please correct me if I am wrong anywhere

 

[2ray]

We are using 2 models. One for the full build on the weekend and the other model we use during the week for incremental.