LU Table Properties

The Table Properties tab is displayed in the right pane of the Table's window.

image

The Properties tab displays a list of properties that must be defined for each LU table, as follows:

Main

Non-editable fields:

  • Name, LU table name.
  • ID, generated by Fabric.

Instance ID Column

A unique field that is used as the LU table Instance ID.

Columns Collation

There are three options:

  • BINARY, (default) compares the exact string in the field with the SQL statement.
  • NOCASE, enables the Select statement to ignore upper / lower case fonts when comparing text fields. For example:
    Select TYPE from tblExample where NAME = ‘value’ returns records when the NAME field is set either to ‘VALUE’ or ‘value’.
  • RTRIM, enables the Select statement to ignore white space characters on the right of the string when comparing text fields. For example:
    Select TYPE from tblExample where the NAME = ‘value’ returns records that match both ‘value’ and ‘value ‘.

Full Text Search

When set to True, enables the use of the MATCH Sqlite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False.

Click for more information about the Match command:

http://www.sqlite.org/fts3.html#section_3

Sync Method

There are four Sync methods:

  • None.
  • Inherited (default).
  • Time Interval.
  • Decision Function.

Truncate Before Sync

When Truncate Before Sync = True, the entire LU table is truncated before the populations are executed.

Enrichment Functions

Enrichment Functions which are executed after all LU tables are populated.

  • The execution order is determined on an LU level and based on the Sync policy of the attached table. When no Enrichment function is attached - displays ‘Empty’.
  • When one or more Enrichment functions are attached – displays ‘<x> enrichments’ (where <x> is the number of attached Enrichment functions).

To select an Enrichment function, click the three dots next to the Enrichment functions property and select the function name. Only functions without input and output parameters are displayed.

On Change

Trigger functions which are executed when there is a change in LU table's data.

To select a Trigger function, click the three dots next to the On Change property and select the function name. Only Trigger functions are displayed.

Previous

LU Table Properties

The Table Properties tab is displayed in the right pane of the Table's window.

image

The Properties tab displays a list of properties that must be defined for each LU table, as follows:

Main

Non-editable fields:

  • Name, LU table name.
  • ID, generated by Fabric.

Instance ID Column

A unique field that is used as the LU table Instance ID.

Columns Collation

There are three options:

  • BINARY, (default) compares the exact string in the field with the SQL statement.
  • NOCASE, enables the Select statement to ignore upper / lower case fonts when comparing text fields. For example:
    Select TYPE from tblExample where NAME = ‘value’ returns records when the NAME field is set either to ‘VALUE’ or ‘value’.
  • RTRIM, enables the Select statement to ignore white space characters on the right of the string when comparing text fields. For example:
    Select TYPE from tblExample where the NAME = ‘value’ returns records that match both ‘value’ and ‘value ‘.

Full Text Search

When set to True, enables the use of the MATCH Sqlite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False.

Click for more information about the Match command:

http://www.sqlite.org/fts3.html#section_3

Sync Method

There are four Sync methods:

  • None.
  • Inherited (default).
  • Time Interval.
  • Decision Function.

Truncate Before Sync

When Truncate Before Sync = True, the entire LU table is truncated before the populations are executed.

Enrichment Functions

Enrichment Functions which are executed after all LU tables are populated.

  • The execution order is determined on an LU level and based on the Sync policy of the attached table. When no Enrichment function is attached - displays ‘Empty’.
  • When one or more Enrichment functions are attached – displays ‘<x> enrichments’ (where <x> is the number of attached Enrichment functions).

To select an Enrichment function, click the three dots next to the Enrichment functions property and select the function name. Only functions without input and output parameters are displayed.

On Change

Trigger functions which are executed when there is a change in LU table's data.

To select a Trigger function, click the three dots next to the On Change property and select the function name. Only Trigger functions are displayed.

Previous