Sample XML and CSV files

This section contains sample XML mapping definition and sample CSV files for Workload Requirements.

<table-config>
    <table name="ES_WORKLOAD_REQ" transaction-type="INSERT_UPDATE" key-fields="WBT_ID,DP_ID,WLR_DATE" primary-key="WLR_ID">
        <fields>
            <field index="1" db-field="WBT_ID">
                <reference table-name="WORKBRAIN_TEAM" supplied-value="WBT_NAME" resolve-to-field="WBT_ID"/>
            </field>
            <field index="2" db-field="JOB_ID">
                <reference table-name="JOB" supplied-value="JOB_NAME" resolve-to-field="JOB_ID"/>
            </field>
            <field index="3" db-field="WRKLS_ID">
                <reference table-name="ES_WORKLOAD_SOURCE" supplied-value="WRKLS_NAME" resolve-to-field="WRKLS_ID"/>
            </field>
            <field index="4" db-field="DP_ID">
                <reference table-name="DAY_PART" supplied-value="DP_NAME" resolve-to-field="DP_ID"/>
            </field>
            <field index="5" db-field="WLR_REQ"/>
            <field index="6" db-field="WLR_DATE" date-format="yyyyMMdd"/>
            <field index="7" db-field="WLR_LAST_UPDATED" date-format="yyyyMMdd"/>
            <field index="8" db-field="WLR_FLAG1"/>
            <field index="9" db-field="WLR_FLAG2"/>
            <field index="10" db-field="WLR_FLAG3"/>
            <field index="11" db-field="WLR_FLAG4"/>
            <field index="12" db-field="WLR_FLAG5"/>
            <field index="13" db-field="WLR_UDF1"/>
            <field index="14" db-field="WLR_UDF2"/>
            <field index="15" db-field="WLR_UDF3"/>
            <field index="16" db-field="WLR_UDF4"/>
            <field index="17" db-field="WLR_UDF5"/>
        </fields>
    </table>
</table-config>

MOB_DEPT_A,CLERK,TEMPLATE,AUTO_DAY12,30,20220101,20220101