Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
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
Hi,
It would be better if you post script code that you have in place... it will be easy to give particular solution based on the script..