Sample XML and CSV files

Sample XML mapping definition

<table-config>
         <table name="RTSS_GROUP_EMP" transaction-type="INSERT_UPDATE" key-fields="EMP_ID,RTSSGE_EFF_END_DATE,RTSSGE_EFF_START_DATE,RTSSG_ID" primary-key="RTSSGE_ID">
             <fields>
                 <field index="1" db-field="RTSSG_ID"/>
                 <field index="2" db-field="EMP_ID">
                     <reference table-name="EMPLOYEE" supplied-value="EMP_ID" resolve-to-field="EMP_ID"/>
                 </field>
                 <field index="3" db-field="RTSSGE_EFF_START_DATE" date-format="yyyy-MM-dd" default-value="!SYSTEM_DATE"/>
                 <field index="4" db-field="RTSSGE_EFF_END_DATE" date-format="yyyy-MM-dd" default-value="30000101"/>
                 <field index="5" db-field="RTSSGE_FLAG1"/>
                 <field index="6" db-field="RTSSGE_FLAG2"/>
                 <field index="7" db-field="RTSSGE_FLAG3"/>
                 <field index="8" db-field="RTSSGE_FLAG4"/>
                 <field index="9" db-field="RTSSGE_FLAG5"/>
                 <field index="10" db-field="RTSSGE_UDF1"/>
                 <field index="11" db-field="RTSSGE_UDF2"/>
                 <field index="12" db-field="RTSSGE_UDF3"/>
                 <field index="13" db-field="RTSSGE_UDF4"/>
                 <field index="14" db-field="RTSSGE_UDF5"/>
             </fields>
         </table>
     </table-config>

Sample CSV file

10001,5516,2022-11-01,2022-11-30

10001,5515,2022-11-01,2022-11-30,Y,N,Y,N,Y,UDF1,UDF2,UDF3,UDF4,UDF5

10001,5515,2022-11-01,2022-11-30,,N,Y,N,,UDF1,UDF2,,UDF4,UDF5