Control flow of extracts and loads

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Control flow of extracts and loads</name>
     <description>Deletes rows from destination tables first then streams data. Creates tables if needed.</description>
     <script>del_recs_stream_data</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 scope="single"> 
             <name>delete_employee</name>
             <load>
                <sql>
                   delete from employee;   
               </sql> 
               <onexception action="ignore"/>    
             </load>
          </destination>

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

<destination scope="single"> 
             <name>delete_photo</name>
             <load>
                <sql>
                   delete from emp_photo;    
               </sql> 
               <onexception action="ignore"/>    
             </load>
          </destination>

<destination>
               <name>employee</name>
               <metadata>yes</metadata>
               <load stream="true" />
          </destination>

<destination>
               <name>emp_resume</name>
               <metadata>yes</metadata>
               <load stream="true" />
          </destination>

<destination>
               <name>emp_photo</name>
               <metadata>yes</metadata>
               <load stream="true" />
          </destination>
          
     </destinations>
</scenario>