Next >> << Prev  

14.2. Column Definitions Form


Before you can load a data file in a destination table with a load job, you need to know the columns available in both the data file and the destination table.

The column definition form is where you can look up and edit the column definitions for data files and target tables. It's accessible for any load job in the Load Mapping area by clicking on the Column Definitions link.

 

 

14.2.1. Common Fields

The fields at the top of the form are common to both the "Data File Columns" and "Destination Table Columns" tabs. They are all read only.

Job Name: Name of the underlying load job for which the form displays column definitions

Data File Format: Format of the data file for which the form displays column definitions

Data File Name: Name of the data file for which the form displays column definitions

Dest. Schema: Database schema of the destination table for which the form displays column definitions

Dest. Table: Name of the destination table for which the form displays column definitions

 

 

14.2.2. Data File Columns

Click on the "Data File Columns" tab to access the data file columns definition.

Column Definitions Form

This tab shows the columns available in the data file.

"Lookup File Columns" button: Click on this button to read the data file structure and display the list of available columns in the grid below.

"Lookup Table + File Columns" button: Click on this button to read in one go the definitions for both the data file and the destination columns, and display the available columns in the grid below.

The data file columns grid contains 4 columns:

  • Name: Name of the column as found in the data file. The first row of a data file is usually a header row that contains the column names. If the data file doesn't have a header row, the columns are named by their position in the file (e.g. Column1, Column2, etc).
  • From Pos: Column start position for a fixed length data file.
    This column will be used in a later version of DMT.
  • To Pos: Column end position for a fixed length data file.
    This column will be used in a later version of DMT.
  • Size: Size of a column for a fixed length data file.
    This column will be used in a later version of DMT.

The buttons on the right hand side of the grid are used to manually add, delete, and move columns up and down in the grid.

The first time you open this form for a new job or a new data file, no columns are displayed. Click on the "Lookup File Columns" button to lookup the columns in the data file.

The refresh of data files columns is not automatic. If the data file has changed (i.e. more or less columns, column names or order) you need to click on the "Lookup File Columns" button to refresh the columns from the latest version of the data file.

If the data file for the underlying load job is not available (e.g. not yet generated), you can create data file column definitions manually with the right hand side buttons.

 

 

14.2.3. Destination Table Columns

Click on the "Destination Table Columns" tab to access the destination table columns definition.

Column Definitions Form

This tab shows the columns available in the destination table.

"Lookup Table Columns" button: Click on this button to read the destination table structure and display the list of available columns in the grid below.

"Lookup Table + File Columns" button: Click on this button to read in one go the definitions for both the data file and the destination columns, and display the available columns in the grid below.

The destination table columns grid contains 4 columns (all of them are read only):

  • Name: Name of the column as found in the destination table
  • Required: Indicate if the column is required
  • Type: Data type of the destination column (e.g. String, Integer, etc)
  • Size: Size of a the destination column

The first time you open this form for a new job or a new destination table, no columns are displayed. Click on the "Lookup Table Columns" button to lookup the columns in the destination table.

The refresh of destination table columns is not automatic. If the destination table has changed (i.e. more or less columns, column names or order) you need to click on the "Lookup Table Columns" button to refresh the columns from the latest version of the destination table.

If the destination table for the underlying load job is not available, you cannot create column definitions manually. The destination table needs to be created first before you can run a load.