Increamental Load Scenarios

[sunilkumarqv]

  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 ?

[sundarakumar]

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]

Okay post some script of that .

[sundarakumar]

PFA

-Sundar

[sunilkumarqv · Accepted solution]

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]

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