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 a status of New
Existing Name
If there is a field with the same name as the column, the source of the field (that is, 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 a status of 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 a status of 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. Once this scenario is encountered, the Transformation Process can only resolve to creating a new field.
This situation is indicative of there being issues with the source table definitions.
These fields will have a status of Mismatch and the source table will also be flagged as a Mismatch.
It is strongly recommended that the source tables and columns be investigated to determine the cause of the mismatch.
Finish
Once the Finish button is clicked, the fields and tables will be created.
This may take a few minutes, depending on the volume of tables and columns being loaded.
