Incremental load

[#1]

hi ,

Is there a way to do an incremental update of the data (only reload new data)

without loading the entire data of the db.

[crusader_]

Hi Faryal,

You can try to use Partial Reload.

P.S.  Be carefull with QUALIFY statement in script.

Check this DOC. Partial Reload Easy and Simple

Hope it helps.

Andrei

[alexandros17]

The easiest way is to use where condition, something like:

Load

*

where mydate > datelimit

so all new items will be loaded (I've done the example with a date, the most common situation)

Hope it helps

[arsal_90]

Hi Faryal

Attached files may help you and if you still have any problem then let me know

[#5]

i don't understand partial RELOAD how it's work

[crusader_]

In script you add "ADD" before LOAD statement.

And you should use Ctrl+Shift+R instead of Ctrl+R - to reload script.

When "compiler" see ADD or REPLACE word  before LOAD it checks for changes in loaded table and add (or replace) only new (or changed) data.

[#7]

Hi Faryal,

You can make a new DBfile like QVD by using just 'Reload'

and dont need a entire data.

you just add 'plus content' on previous file.

I used concatenate.