topic Delta load vs incremental load in QlikView

Delta load vs incremental load

deepakqlikview_123 — Thu, 03 Apr 2014 10:04:29 GMT

Hello All,

Can you please tell me what is difference between delta load and incremental load.

Thanks

Re: Delta load vs incremental load

MK_QSL — Thu, 03 Apr 2014 10:09:21 GMT

Types of loads in Qlikview

Looks like both are same 🙂

Re: Delta load vs incremental load

its_anandrjs — Thu, 03 Apr 2014 10:18:23 GMT

Both are same some says Delta in other languages and in qlikview incremental means increase row one by one add or weather delete

Find the attached doc.

Re: Delta load vs incremental load

VishalWaghole — Thu, 03 Apr 2014 10:26:00 GMT

Hi Deepak,

Delat Load and Incremental load is same,

List of Load Types in Qlikview :

1. Loading data from the file.

2. Inline Load

3. Resident Load

4. Incremental Load

5. Binary Load

6. Add Load

7. Buffer Load

- Regards,

Vishal Waghole

Re: Delta load vs incremental load

arjunkrishnan — Thu, 03 Apr 2014 10:44:22 GMT

A delta load, by definition, is loading incremental changes to the data. When doing a delta load to a fact table, for example, you perform inserts only... appending the change data to the existing table.