topic Re: Increamental Load Scenarios in QlikView

Increamental Load Scenarios

sunilkumarqv — Fri, 21 Feb 2014 12:16:11 GMT

Hi all,

I want to do update and insert increamental load that sopisticated to no of tables in sql .I'm not generated Qvd 's or stored into qvd from source have multiple tables somehow concatenated and other are remain .So i have a Date as Key so without generating Qvds

How to do increamental Load that to mulple Tables ?

Re: Increamental Load Scenarios

sundarakumar — Fri, 21 Feb 2014 12:32:43 GMT

Incremental load is something where you store things into qvd and get the data out of it (since it will work fast that the normal load.) we will be just loading the data that is not actually present in the qvd from the database or someother source... If u dont want to generate qvd then you can probably do a full load all time...

-Sundar

Re: Increamental Load Scenarios

sunilkumarqv — Fri, 21 Feb 2014 12:35:25 GMT

Okay post some script of that .

Re: Re: Increamental Load Scenarios

sundarakumar — Fri, 21 Feb 2014 12:37:03 GMT

PFA

-Sundar

Re: Increamental Load Scenarios

sunilkumarqv — Fri, 21 Feb 2014 12:49:14 GMT

These scernoirs what you send is very basic would you post somthing like sql database having multiple tables some tables are concatenated and other are remain I dont have timestamp rather that have Date.My Question is How To do update and insert for these scenarios?

Let consider these scenorios

//For Concatenated tables

TabA;

Load * From Datasource;

concatenate

TabB;

Load *From Datasource;

concatenate

TabC;

Load From Datasource;

//Normal table

TabD

Load * Datasource;

Re: Increamental Load Scenarios

sundarakumar — Fri, 21 Feb 2014 12:57:04 GMT

sorry i dont have any complex scenario examples...

As far as i know you should first get the data from the data souce without doing any processing in it like concatenating or joining ,etc (implemention the incremental load) then use resident to do all modifications u want.

-Sundar