Sample XML mapping definition and CSV files

Sample XML mapping definition

<table-config>
    <table name="HOLIDAY_CAL_EMP" transaction-type="INSERT_UPDATE" key-fields="HCAL_ID,EMP_ID" primary-key="HCALEMP_ID">
        <fields>
            <field index="1" db-field="HCAL_ID">
                <reference table-name="HOLIDAY_CALENDAR" supplied-value="HCAL_ID" resolve-to-field="HCAL_ID"/>
            </field>
            <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="HCALEMP_FLAG1"/>
            <field index="4" db-field="HCALEMP_FLAG2"/>
            <field index="5" db-field="HCALEMP_FLAG3"/>
            <field index="6" db-field="HCALEMP_FLAG4"/>
            <field index="7" db-field="HCALEMP_FLAG5"/>
            <field index="8" db-field="HCALEMP_UDF1"/>
            <field index="9" db-field="HCALEMP_UDF2"/>
            <field index="10" db-field="HCALEMP_UDF3"/>
            <field index="11" db-field="HCALEMP_UDF4"/>
            <field index="12" db-field="HCALEMP_UDF5"/>
        </fields>
    </table>
</table-config>

Sample CSV files

29,5512

36,5510,,N,Y,N,,UDF1,UDF2,,UDF4,UDF5