I have a scenario, could you please help me on this.
I have a QV app, with 10 Tables ,1 fact, 9 dimension, fact table is created with an incremental load.
the incremental operation will perform on daily basis, now I want to delete particular date data, and in place of it I want to update with new data on that date. for this I would like to provide a button in the "UI" when user clicks on it, app should take the date and delete the data that is associated with that date and it should append the newly updated data corresponding to that date.