Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have a app which has icnremental load (delete+insert).
I need to specify deleted rows with flag how can i achive it?
my script is like
//FullLoaddata:loaddatekeyfield1,field2from db;store * into data.qvd;
//vupdatedatetab:load max(date) as maxdateresident data;let vdate = peek('tab',*,'maxdate');drop tables data,tab;
//Incrementalincremental:load datekeyfield1,field2,0 as Deletedfrom dbWhere date > $(vdate );
Concatanate*from data.qvd;
From here i need to fetch deleted rows and concatanate it to incremental table with "1 as Deleted" field(flag)how can i achieve this???