LU Table Properties

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

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 PK Column	A unique field that is used as the LU table’s Primary Key.
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.

LU Table Properties

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

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 PK Column	A unique field that is used as the LU table’s Primary Key.
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.