Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a view coming from a oracle, this view will update every day until Sunday night and Sunday night it gets wipes off and on Monday it starts refreshing again until Friday night
Need to store this for history in form of QVD's
Thanks,
D
Hi.
There're at least three ways to achive this.
1. You can try to create incremental load based on unique key provided by view and set automatic reload in qmc for in specific timerate.
2. If you know exact date of view wipeout you can set reload just before wipeout - this is risky in my opinion.
Resolution nr 3 is conversation with persons which manages your database and ask them to create another view for prev. week and then set reload for prev. week on mondays. In my opinion this is the simplest way.