I have got a fact table which is getting data on a hourly basis.I need to transfer this data into the cube.
The problem here is that the previous data should not get modified and this hourly data should be appended to the original data.After doing the data transfer I am deleting the data from the fact table.
I am using the Incremental process option for this task.
But I am not able to append the data,instead the data is getting overwritten.
I have tried this for dimensions too. First I am doing the ProcessUpdate option for dimensions and then doing the ProcessIncremental for cube.This is also not giving the correct result.
Please help me on this isue. Any help is welcome.