Hello,
I have a snapshot fact table that stores the data for last 9 days (D1-D9). Every day in the ETL load, we remove the D9 and add D1 data to the fact. Existing D1 becomes D2 and D2 become D3 and so on.
We have created measure group on the fact and created 9 partitions, one for each day.
How can we do the incremental processing (Remove D9 and Add D1 and cascade the remaining partitions) like we do it in the ETL.
Regards,
Akash