cancel
Showing results for 
Search instead for 
Did you mean: 

Open hub destination

Former Member
0 Kudos

Hi All,

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.

Thanks,

Satya

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Dear Satya,

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.

Regards,

Srinivas.