New Field or Update Existing?

For most situations, determining how to handle a column is relatively simple.

New Name

If there is no field with the same name as the column, a new field is created. The source tables are recorded against the field for future reference.

These fields will have the status New.

Existing Name

If there is a field with the same name as the column, the source of the field (i.e. the tables from which it is derived) are compared to the tables being loaded. If the tables match, the field is updated with the column attributes.

These fields will have the status Changed.

Existing Name and Partial Reload

When a name match is found and the column attributes have changed, the source tables are assessed. If they are not the same, the transformation process cannot determine what to do. The field is being used in multiple LANSA tables, but not all source table information is available.

These fields will have the status Partial Reload.

A drop-down is provided so that you can determine whether the field should be updated, a new field created, or the change ignored.

Existing Name and Mismatch

When loading multiple tables, it is possible that the same column name has different attributes from each source table and these may not match the LANSA field. If this scenario is encountered, the Transformation Process can only resolve to create a new field.

This situation is indicates there are issues in the source table definitions.

These fields have a status of Mismatch and the source table are also flagged as a Mismatch.

The source tables and columns need to be investigated to determine the cause of the mismatch.