Migrate data, including CLOBs and BLOBs

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Migrate data, including CLOBs and BLOBs</name>
     <script>move_data</script>
     <driver>com.toolsverse.etl.driver.oracle.OracleDriver</driver>
     <sources>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee</sql>
               </extract>
          </source>

<source>
               <name>emp_resume</name>
               <extract>
                    <sql>select * from emp_resume</sql>
               </extract>
          </source>

<source>
               <name>emp_photo</name>
               <extract>
                    <sql>select * from emp_photo</sql>
               </extract>
          </source>
          
     </sources>
     <destinations>
          <destination>
               <name>employee</name>
               <tablename>employee_move</tablename>
               <metadata>yes</metadata>
          </destination>

<destination>
               <name>emp_resume</name>
               <tablename>emp_resume_move</tablename>
               <metadata>yes</metadata>
               <load>
                  
                  <variables>
                      <RESUME nativetype="CLOB" />
                  </variables>
               </load>
          </destination>
          
          <destination>
               <name>emp_photo</name>
               <tablename>emp_photo_move</tablename>
               <metadata>yes</metadata>
          </destination>
          
     </destinations>
</scenario>