Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have small data. There's data transformation involved & I would like to do incremental load to QVD every month
Is it possible to store all the data into excel file besides QVD?
Reason:
- To backup all the data if anything happen
- It's easy to do modification if we load data wrongly
You can store to TXT as an alternative to QVD.
Just use 'store .. into ... .txt (txt)';
If you do a correctly structured insert, update and delete incremental load the data will be corrected during reload.
Thanks Michiel but if i store it into .txt, i can't easily modify it and reload it again
Why i need to keep track? Because the data structure is not fix all the time