incremental load pls explain me step by step pls..............................

[#1]

incremental load pls explain me step by step  pls..............................urgently.........................

[Anonymous · Accepted solution]

Incremental load – it loads only the new or changed records from Database.

It can dramatically reduce the time needed to reload a qlikview application.

Basic incremental load process

1. Load new data from database table(slow, but few records)
2. Load old data from QVD file(many records,but fast)
3. Create new QVD file
4. Repeat procedure for each table

We have various scenarios for incremental load:

1. Daily Incremental reloads (Insert/Update)
2. Multi-QVD incremental reloads
3. Frequent incremental Reloads (Insert Only) –Utilizes binary load approach
4. Historical data management using Daily/Monthly Stacked QVDs
5. Incremental Reloads (Insert/Update/Delete) with deletion flag available.
6. Incremental Reloads (Insert/Update/Delete) with deletion flag available.

Basic Process:

QV_ILoad:

SQL SELECT PrimaryKey,X,Y FROM DATABASETABLE

WHERE ModificationTime>=#$(LastExecTime)#;

Concatenate

LOAD PrimaryKey,X,YFROM File.QVD;

[maxgro]

I found two old docs, hope the help you

[#4]

hi Manoj,

load table into qv make qvd and comment entire script.

load qvd file into qv. using let statement save last rec data.

load data base table into qv and write "where data >= $(variblename) .be four load write NoCancat statement.

load table into qv and write "where not exists(...ID)"; be four load write Cancat statement

write store tablename into c:.............\tablenale.qvd(qvd)

[Anonymous]

Manoj

There are quite few excellent blog posts on Incremental Loads.  Here is link to one of them.

    http://www.quickintelligence.co.uk/qlikview-incremental-load/

Best Regards

[#6]

Can you please help me in "Incremental Reloads (Insert/Update/Delete) with deletion flag available"

Can you give some example.

Thanks in Advance.