Add dimension

<?xml version="1.0" encoding="UTF-8"?>
<scenario parallel="true">
     <name>Add dimension</name>
     <script>add_dimension</script>
     <sources>
          <source>
               <name>emp_photo</name>
               <extract>
                    <sql>select * from emp_photo</sql>
               </extract>
          </source>
          <source>
               <name>employee</name>
               <extract>
                    <sql>select * from employee where empno in (select empno from emp_photo)</sql>
               </extract>
               <tasks>
                    <task noconnection="true">
                         <name>add_dimension</name>
                         <class>com.toolsverse.etl.core.task.common.AddDimension</class>
                         <variables>
                              <JOIN value="EMP_PHOTO"/>
                              <KEYS value="EMPNO"/>
                              <KEEPALL value="true"/>
                         </variables>
                    </task>
               </tasks>
          </source>
     </sources>
     <destinations>
          <destination>
               <name>EMPLOYEE_PHOTO_JSON</name>
               <source>EMPLOYEE</source>
               <owner>EMPLOYEE_PHOTO</owner>
               <load/>
          </destination>
     </destinations>
</scenario>