Merge data

<?xml version="1.0" encoding="UTF-8"?>

<scenario>
     <name>Merge data</name>
     <description>Merges data. Creates table if needed.</description>
     <script>merge_data</script>
     <driver>auto</driver>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination>
               <name>employee_merge</name>
               <tablename>employee_merge</tablename>
               <source>employee</source>
               <metadata>yes</metadata>
               
               
               <load action="merge" key="EMPNO"> 
                                     
                   <variables>
                       <JOB code="var value;value = '\'abc\'';" lang="JavaScript" />
                       <SALARY code="var value;value = row + 1;" lang="JavaScript" />
                   </variables>
               </load>
          </destination>   
     </destinations>
</scenario>