Using MySql cursors in the etl scenario

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Using MySql cursors in the etl scenario</name>
     <description>Using MySql cursors in the etl scenario</description>
     <script>mysql_cursor</script>
     <driver name="com.toolsverse.etl.driver.mysql.MySqlDriver"/>
     <allow>EXTRACT_LOAD</allow>
     <onsave action="save"/>
     <tasks>
          
          <task>
               <name>trunk_staging_table</name>
               <connection>dest</connection>
               <class>com.toolsverse.etl.core.task.common.SqlTask</class>
               <sql>
                   TRUNCATE TABLE employee_stage;
               </sql>
               <onexception action="ignore"/>
          </task>
     </tasks>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee</sql>
               </extract>
          </source>
     </sources>
     <destinations>
          <destination scope="single">
               <name>employee_stage</name>
               <source>employee</source>
               <metadata>true</metadata>
          </destination>
          <destination>
               <name>EMPLOYEE_CURSOR</name>
               <metadata use="true"/>
               <cursor sql="select * from employee_stage"/>
          </destination>
          <destination>
               <name>employee_cursor_table</name>
               <metadata>true</metadata>
               <cursor onfinish="drop" table="employee_stage"/>
          </destination>
     </destinations>
</scenario>