Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sunilkumarqv
Valued Contributor II

Increamental Load Scenarios

  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 ?

1 Solution

Accepted Solutions
sunilkumarqv
Valued Contributor II

Re: Increamental Load Scenarios

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;

5 Replies
sundarakumar
Valued Contributor II

Re: Increamental Load Scenarios

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

sunilkumarqv
Valued Contributor II

Re: Increamental Load Scenarios

Okay post some script of that .

sundarakumar
Valued Contributor II

Re: Re: Increamental Load Scenarios

PFA

-Sundar

sunilkumarqv
Valued Contributor II

Re: Increamental Load Scenarios

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;

sundarakumar
Valued Contributor II

Re: Increamental Load Scenarios

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

Community Browser