Using PostgreSQL cursors in the etl scenario

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Using PostgreSQL cursors in the etl scenario</name>
     <script>postgres_cursor</script>
     <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
     <allow>EXTRACT_LOAD</allow>
     <tasks>
          
          <task>
               <name>trunk_staging_table</name>
               <connection>dest</connection>
               <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
               <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>true</metadata>
               <cursor sql="select * from employee_stage"/>
          </destination>
          <destination>
               <name>employee_cursor_table</name>
               <metadata>true</metadata>
               <cursor table="employee_stage" onfinish="drop" />
          </destination>
     </destinations>
</scenario>