Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

WHat is incremental load ??

HEy,

WHat is incremental load ?? WHy it is used ?? Can any one give an example ??

18 Replies
its_anandrjs

You can search Qlik community for this and get many post related to this.

tresesco
MVP
MVP

One of them:

Incremental Load

its_anandrjs

You can read this useful document also for get an idea for Incremental load.

MayilVahanan

Hi

Please refer this

http://community.qlik.com/search.jspa?q=incremental+load#type=document

Additional with above suggestion:

Incremental Load Scenarios.pdf

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
nikhilgarg
Specialist II
Specialist II
Author

Hey ,

I read the ppt at this given link but i still didnt get the perfect idea why incremental load is used ?? Is it used for doing operations on log files only ??

Please help me understanding incremental load.

Thanx.

nikhilgarg
Specialist II
Specialist II
Author

Hey ,

I read the ppt at this given link but i still didnt get the perfect idea why incremental load is used ?? Is it used for doing operations on log files only ??

Please help me understanding incremental load.

Thanx.

Not applicable

Incremental load --> appending delta on history data instead of fetching all data from source system

Siva_Sankar
Master II
Master II

Nikhil,

Consider the following example..

A company may have two platforms, one that processes orders, and a seperate accounting system. The accounts department enters new customer details into the accounting system but has to ensure these customers appear in the order processing system.

To do this it runs a nightly batch job that sends data from the accounting system to the order system.

If they were deleting all customer details in the order system and refilling with all the customers in the accounting system then they would be performing a full reload which takes long time.

If they only sent accross the new customers and the customers that had been changed they would be performing an incremental load which means the incremental load will keep the old data as it is and load only new data. Consumes less load time.

Find the attachment for detail information

nikhilgarg
Specialist II
Specialist II
Author

Hey,

But to reduce load time and load new data , partial load can be used. Right ??