In my data load editor, In my first section I have added an sql query(Table 1) and in the second section I have created an Mapping table and resident to above Table 1. Then in same section, I have a new table(Table 2) and added all fields from Table 1 and resident to Table 1. Then I have dropped the Table 2;
Then app has other sections as well! Now I need to partial load this. Added the keyword in front of select statement in table 1, and in front of load statement in Mapping & Table 2. I have a enabled button action to partial reload. Is this partial reload done in the correct way or what's the best way to define it ?
Table1: Add SQL select m.MATREQ_BASICID ...
Map_Max_Rate: Mapping Add LOAD PACKING_DOCID&PITEMCODE, max(COSTRATE) Resident Table1 Group By PACKING_DOCID&PITEMCODE;
Table2: Add LOAD PACKING_DOCID, ... as LINK1 Resident Table1; Drop table Table1;
