Sample XML and CSV files
This section contains sample XML mapping definition and sample CSV files for Billboard Group Employee.
<table-config>
<table name="OSB_GROUP_EMPLOYEE" transaction-type="INSERT_UPDATE" key-fields="OSBG_ID,EMP_ID,OSBGE_START_DATE,OSBGE_END_DATE" primary-key="OSBGE_ID">
<fields>
<field index="1" db-field="OSBG_ID">
<reference table-name="OSB_GROUP" supplied-value="OSBG_ID" resolve-to-field="OSBG_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="OSBGE_START_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="!SYSTEM_DATE"/>
<field index="4" db-field="OSBGE_END_DATE" date-format="yyyy-MM-dd HH:mm:ss" default-value="30000101"/>
<field index="5" db-field="OSBGE_FLAG1"/>
<field index="6" db-field="OSBGE_FLAG2"/>
<field index="7" db-field="OSBGE_FLAG3"/>
<field index="8" db-field="OSBGE_FLAG4"/>
<field index="9" db-field="OSBGE_FLAG5"/>
<field index="10" db-field="OSBGE_UDF1"/>
<field index="11" db-field="OSBGE_UDF2"/>
<field index="12" db-field="OSBGE_UDF3"/>
<field index="13" db-field="OSBGE_UDF4"/>
<field index="14" db-field="OSBGE_UDF5"/>
</fields>
</table>
</table-config>
Sample CSV files
1001,5516,2022-10-20 00:00:00,2022-10-30 00:00:00
1001,5515,2022-10-20 00:00:00,2022-10-30 00:00:00,Y,N,Y,N,Y,UDF1,UDF2,UDF3,UDF4,UDF5