Unassigned or multiple-assigned fields and columns

The High-Performance Loader (HPL) does not require a one-to-one connection between the fields and columns. You can map a field to multiple columns. Figure 2 shows a map where the data from one field is placed into two columns.

You can also have a column that has no mapping association. Field 1 in the Format pane in Figure 2 does not have an association. If a column does not receive input, onpload sets the column to null.

Copyright© 2018 HCL Technologies Limited