Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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;
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
Okay post some script of that .
PFA
-Sundar
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;
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