topic Re: Incremental Load in QlikView

Incremental Load

konidena — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

With my basic knowledge in Incremental Load, we can load the data in the following 3 ways.

1. Insert

2. Insert and Update

3. Insert, update and Delete

I have the below data...

Sales table.

Sales

Region,

Customer,

Date of Sale

From the above fields, i am considering the max value of the Date of Sale and while loading the new records into qv, i have to consider the records which are after the max value of the date of sale.

New records will be concatenated to the old records and new QVD will be created for sales data.

Question: If i have other tables which don't have the date field. How to do the incremental load?

A data model can be made by list of tables. Only few tables have data fields wherever required. But some of the tables don't have the date fields. For these type of tables, how to do Incremental load.

Regards

Srinivas

Re: Incremental Load

Chanty4u — Tue, 12 Apr 2016 11:54:30 GMT

chk here

Incremental Load in Qlikview - Sources

Re: Incremental Load

Anonymous — Tue, 12 Apr 2016 12:59:45 GMT

it seems like you have Sales Fact table which contains date field and other tables means dimension tables right ?

if yes you can implement incremental load for fact table only and you can load dim tables normally. basically fact table is major table in any data model which might holds huge amount of data.

Re: Incremental Load

Gysbert_Wassenaar — Fri, 15 Apr 2016 08:46:43 GMT

Question: If i have other tables which don't have the date field. How to do the incremental load?

How can you tell the new/changed records from the current? Is there a numerical field that gets increased with each insert or update?