The Ajilius column editor supports the definition of columns in your data warehouse.

The editor may be invoked by clicking on a hyperlinked column name in a list screen, or by selecting the Change Column link from the Column List context menu.

The fields that may appear on this form are listed below. Note that not all fields will be displayed for all columns, depending on the type of table and type of column being edited.

Form Fields

Table Name Name of the table within which this column is defined.
Source Column

Table and column from which this column is sourced.

This field may be blank for system-generated columns, or where the table from which it was originally sourced has been deleted.

Where the column source has been deleted, a drop-down list will support the selection of a new source column.

Column Name

Object name with which this column will be created in the data warehouse.

Must be non-blank, begin with a letter, and comprise letters, digits and underscores only.

Business Name User-friendly name for this column which describes its purpose, and which will be surfaced in BI tool metadata when generated by Ajilius.
Data Type  Ajilius data type representing the type of data which may be stored in this column:

  • integer
  • numeric.0
  • numeric.2
  • numeric.4
  • numeric.6
  • text
  • longtext
  • boolean
  • date
  • time
  • datetime
  • Custom SQL

If Custom SQL is selected, another field is displayed for the entry of a custom data type in the syntax of the target data warehouse.

 

Column Role

Special role allocated to this column for transformation processing.

Refer to Column Roles documentation for more details.

Transform A list of simple transformations that may be applied to the column when being processed. The source column is wrapped in the transform function when selected from the source table.
Index Column

This checkbox declares a hint to the Ajilius code generator that an index may be desirable on this column.

Note that Ajilius is an index-light product. We do not encourage the creation of indexes, While an index may improve query performance, it will degrade ELT performance.

Please use this feature sparingly.

Custom Calculation

Custom SQL transformations may be used to define columns using this feature.

The field may contain any legitimate SQL statement in the syntax of the target data warehouse.

Note that we do not guarantee the portability of custom code entered in this field, and it may need to be edited when migrating to a new platform.

The drop-down field contains a list of all of the columns in the source join set. Clicking on a field name will paste it into the calculation box at the cursor position. This is a useful shortcut when creating complex calculations from large tables, when remembering column names may be difficult.

 Form Actions

Change Save the column details, close this form, and return to the point from which the form was invoked.
<-Change Save the column details, and display this form for the previous column in the table.
Change-> Save the column details, and display this form for the next column in the table.
Cancel Close this form without saving changes, and return to the point from which the form was invoked.