Hi Gurus,
I really need help for this.
I am trying to build the power cube(transformer) everyday incrementally. The cube is patitioned by month. But incremental load is inserting duplicate data because my source can be updated 5 days back data. I can't do the full cube build everyday because of data volume and time to build it. My cube is partitioned by month. Now my question is : is it possible to full build the cube everday by partition, so that everyday I will do full build only the last month partition and that will solve my problem of inserting duplicate records(which are updated but not inserted in the source).
Please let me know if anyone knows about it. Also, if any workaround.
As of me its not possible to do incremental update when you have partitioned the cube by month wise.
Clarify me is it possible to apply both incremental update and paritioning on a cube Simultaneously.
While applying incremental update your database should contain only current data. It should not contain previous data. If it contains previous data it will insert the duplicate data into you cube.