i have a fact table and i have to apply incremental logic for insert and update rows in fact table
in such a way that it should also store historic data for 6 months.
Because , if i apply only insert and update incremental logic it will not store the historic data.
I want historic data for only 6 months .
ie if i load the data in junly month then it should store historic data only from jan to june.
Can anyone help me in this.
Thanks in advance