Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental

Hi,

Can someone tell me what is difference b/w 1)insert only and 2)insert and update methods.

1)Technically speaking in first case we are just checking modified time of DB table is greater than  lastloadtime of qvd data.

2)For the second case we are doing as above said+by using where does not exist Primary Key in qvd.

Whether my understanding correct. 

2 Replies
Gysbert_Wassenaar

Insert only means that only records are added. Often a check is used to only load new records from later than the records already loaded earlier.

Insert and update means not only inserting new data, but updating existing records too if there are changes. An example could be updating customer addresses that haved changed since the last insert/update.


talk is cheap, supply exceeds demand
Not applicable
Author

In technical terms , We will take only those records where primary key not exists in database table for insert and update method.

But for insert only method we wil just not check like above.

Is it correct.