Limitations of Missing Column check
The check for missing columns will only examine and check those columns that are recorded in the source table and source column fields of a load table's column properties. Therefore if a source column is used in a transformation or join, but is not recorded in the two fields mentioned above it will not be checked.
If a column is used in a transformation, it should have the same usage (name and case) as is found in the source column and source table fields.
This check has no upper limit on the number of missing columns. All columns can be missing and the load will still succeed.
Load Table Transformations
Each load table column can have a transformation associated with it. See
Transformations (on page
569) and
Load Table Column Transformations (on page
573) for more details.
Post-Load Procedures
If a procedure name is entered in the post-load procedure field of a load table's properties, then this procedure will be executed after the load has completed and after any 'after' transformations have occurred.
Changing Load Connection and Schema
The connection associated with a load table can be changed through the properties of that table.
Connections can also be changed in bulk by using the following process:
1 Double click on the 'Load Tables' object group in the left pane. This will display all load tables in the middle pane.
2 Select those load tables that you wish to change using standard Windows selection.
3 Right mouse to bring up a menu and select 'Change Connect/Schema'.
4 Select the new connection to change all the selected load tables.
Note: You cannot change the connection type but it is possible to change from Database to ODBC connections when the following considerations are taken into account.