I have created an Open hub destination on top of a cube. I am storing the data into a database table. Currently i am doing a full load. But I need to do a delta load. The problem is that the current year data in the cube gets dumped and reloaded daily. In this case, how will the delta work ? My question is, can we have a delta from a cube which gets dumped and reloaded( i.e. Current year data ) daily.
Please reply urgently.
In your case delta will be populated from the Open hub destination, If you are reloading one year data from source to target every day by deleting the previous request, the delta will also carry the one year data which will be populated to a source table whcich is the destination of the Open hub destination.
If you feel the one year data is less when compared the entire data in the cube you can go for delta otherwise I suggest full update.