1. My staging table would contain only one day data, and that data has to be pushed in to the cube on a daily basis. For this, I used "load and aggregate" option.
This means the data that was pushed before would not be disturbed. Only the delta is added.
2. My staging table would contain entire data. In this case, the cube has to be populated with the new data and also delete rows in the cube when that corresponding row does not exist in the staging table.
Is there any option other than "clear and load" to achieve this ?