I am developing a file which has huge tables (reload approx. 1 hour) and am developing only one of the tables tables in the file. I was hoping to use the partial reload to update this table, but can't see in the help files how to deal with maps and succeding loads (maps are only coming into this table, none are created from it).
Do I need to replace load the related maps (I guess something like MAPPING REPLACE LOAD ... RESIDENT x;), and are the succeding loads automatically done - how often is the replace required (i.e. REPLACE LOAD ...; SELECT ... FROM x; or REPLACE LOAD ...; SQL REPLACE SELECT ... FROM x;)?
After a bit of playing around, I have found that maps can be reloaded in partial reload with "MAPPING REPLACE LOAD ..." - just make sure you didn't drop the table it maps from (can be reloaded with a REPLACE LOAD if you did).
Succeding loads are automatically loaded so only the first load in the table needs to be a REPLACE LOAD unless you are concatenating (for this use ADD LOAD ...).
This works fine if you aren't changing the structure of the replaced table. If you are it will load as TableName-1 which is annoying, but you can avoid this if you drop the table first with:
I've not used the partial reload before and instead used QVD files and incremental loading, have you considered this approach?
With that method I was able to load my 'new' data only, instead of the entire SQL tables each time. +QVD files are extremely fast and small for storing raw data 🙂
Thanks, but unfortunately this approach will not work for me as the "historic" data is subject to a lot of change, and I would have to change all the code back to look at the source data again after developing just one small table in the file.
After a bit of playing around, I have found that maps can be reloaded in partial reload with "MAPPING REPLACE LOAD ..." - just make sure you didn't drop the table it maps from (can be reloaded with a REPLACE LOAD if you did).
Succeding loads are automatically loaded so only the first load in the table needs to be a REPLACE LOAD unless you are concatenating (for this use ADD LOAD ...).
This works fine if you aren't changing the structure of the replaced table. If you are it will load as TableName-1 which is annoying, but you can avoid this if you drop the table first with:
