You can try something like:
Load * from <Your_qvd> where WEEK >= ...; // for last 7 weeks
Concatenate // it will get concatenated even automatically if all field are same
Load * from <Source_data> where WEEK >=....; // put here condition for latest week only
STORE OldQVDData Into <Your_qvd>;
Hope this helps.
Thanks! That's a good idea.
I'm trying to load the last several weeks from a qvd, but I constantly get error message:
where week>= to_number(to_char(sysdate-42, 'iyyyiw')) and week <= to_number(to_char(sysdate-14, 'iyyyiw'));
How do you make constraints when loading from qvd?