Expert suggestion on Delta Merge of delta data in HANA
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;|