Understanding the Transformation Process

In its simplest form, the transformation converts tables and their columns in to LANSA tables and fields with identical names to the source objects.

Each table becomes a LANSA table and each column becomes a LANSA field. All columns are converted to LANSA data types. The Preview page shows the proposed field and the source details in parentheses.

Many databases have the same column name in multiple tables, and for most scenarios, the definition of the column is the same in all tables. This results in a single field being created that will be used in all the resulting tables.

If there is a difference in the definition in different tables, multiple Fields are created to address the requirements of the different columns.

Columns are assessed based on their data type, length, decimal places and whether they support null assignment.