Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Expert suggestion on Delta Merge of delta data in HANA

Hi Experts,

I am using the below sequence step to refresh the data by calc view in one Z table of my schema. Where I am deleting the data and loading again, if I am writing the below in a Stored Proc and Scheduling in XSJOBS.

Is there any better step where I can only update the delta records , so that I can increase the speed of the XSJOBS, by reducing the run time of data update.

create local temporary table #ZZ_TAB( , );  // Same as CALC_VIEW Structure
insert into #ZZ_TAB
select * from CALC_VIEW;
delete from "CHANDAN_SCHEMA"."ZZ_TAB";
insert into "CHANDAN_SCHEMA"."ZZ_TAB"
select * from #ZZ_TAB;
merge delta of "CHANDAN_SCHEMA"."ZZ_TAB" WITH PARAMETERS ('FORCED_MERGE' = 'ON');
drop table #ZZ_TAB;
Tags:
Not what you were looking for? View more on this topic or Ask a question