<stage-table> / <map>

The <map> elements define how to map data fields to table columns.

column

Required: Column name.

value

Required: Column value.

For example:

<delimited-file start-row="2" delimiter=",">
...<field index="1" name="id" nullable="false"/>
...<field index="2" name="channel"/>
...<field index="3" name="name"/>
</delimited-file>
 
<stage-table table="CUSTOMERS">
...<map column="id" value="${id}"/>
...<map column="class" value="${channel}"/>
...<map column="name" value="${name}"/>
</stage-table>