Destination Exceptions

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Handle exceptions during load</name>
     <script>move_data_exception</script>
     <driver>auto</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>delete_employee</name>
             <load>
                <sql>
                   delete from employee;   
               </sql> 
               <onexception action="ignore"/>    
             </load>
          </destination>

<destination> 
             <name>delete_resume</name>
             <load>
                <sql>
                   delete from emp_resume; 
               </sql> 
               <onexception action="ignore"/>    
             </load>
          </destination>

<destination> 
             <name>delete_photo</name>
             <load>
                <sql>
                   delete from emp_photo;    
               </sql> 
               <onexception action="ignore"/>    
             </load>
          </destination>
     
          <destination>
               <name>employee</name>
               <metadata>yes</metadata>
          </destination>

<destination>
               <name>emp_resume</name>
               <metadata>yes</metadata>
          </destination>

<destination>
               <name>emp_photo</name>
               <metadata>yes</metadata>
          </destination>
          
     </destinations>
</scenario>