Cube Problem
-
I have a cube in which I am putting the data on a regualar basis by running a SSIS package.
I am currently storing my data in partitions of 15 days. I store the datetime upto which I have transferred the data into the cube in a seaprate table and after it I transfer the updated data from my fact table into the cube.E.g Suppose last datetime stored is 15 Aug ,I will transfer the data into the cube from the fact table which has been in the fact table after 15 aug.
But the problem I am facing now is that the newly updated data can contain some of the data of the previous data (of the same datetime)which has been moved to the cube earlier.
So now The problem is want to move only that updated data from the fact table which is not present the cube.
Please help .......any help is welcome....
-
It's a little unclear exactly what you're doing. Consider "Unprocessing" the partition, then processing it full.
If you're trying to update previously process (and assumed complete) partitions, then unprocess those partitions and reprocess as well.
-
If you want to add new data, do an incremental process setting a query that returns just the new rows.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply