topic Re: Incremental Load in QlikView

Incremental Load

jyothish8807 — Fri, 19 Sep 2014 04:39:43 GMT

Hello All,

I am trying to to do incremental load but have a bit of confusion with multiple tables.I have four tables which are comming from different sources.

Table1:

Load *

from ...;

Table2:

Load *

from ...;

Table3:

Load *

from ...;

Table4:

Load *

from ...;

Can any one please help me with this,iam trying to do inceremntal (insert,update,delete) load. Do i require an update date field in all the tables or is it enough to have in one table.All the four tables are connected through primary key.

Regards

Jyothish KC

Re: Incremental Load

ajaykumar1 — Fri, 19 Sep 2014 04:52:18 GMT

Hi,

Please find the attachment its very helpful in easy way(check both application and excel).

Regards,

Ajay

Re: Incremental Load

tresB — Fri, 19 Sep 2014 04:53:13 GMT

If you want incremental load for all tables, the timestamp field has to be there in all the tables. Otherwise, it is normally the case, use incremental load with Fact table(the bigger one), provided the date field is there.

Re: Incremental Load

jyothish8807 — Fri, 19 Sep 2014 05:07:57 GMT

Hi Ajay,

Thanks for this attachment, but this is a basic example of incremental load. I have confusing with multiple tables and complex scripts.

Regards

Re: Incremental Load

jyothish8807 — Fri, 19 Sep 2014 05:16:58 GMT

Hi Tresesco,

Thanks a lot for your feedback, but can you please explain me a little more?

While storing QVD, which table should i store? or do i have to store all the tables seprately and apply incremental load on all the tables?

Is there any way to store all the tables at onces in to one QVD in a go.

I have put each table script in different tabs.Not using concatinate or join, just joining through primary key.

Regards

Re: Incremental Load

tresB — Fri, 19 Sep 2014 05:19:40 GMT

You don't have to put all the tables in one qvd. First check which tables have modification timestamp field. Implement incremental load separately for them.

Re: Incremental Load

jyothish8807 — Fri, 19 Sep 2014 05:45:51 GMT

My all four sheets can be modified by any one, so i think i will need Timestam field in all of my sheets.

Re: Incremental Load

jyothish8807 — Fri, 19 Sep 2014 06:49:49 GMT

Any help?