Create an LU Table

How Do I Create a New LU Table?

LU tables are the basic building blocks for creating Logical Units. There are several ways to create a new LU table.

From the LU schema:

  • Right click the work area and select either the New Table From SQL Based DB Query or New Table From SQL Based Root Function option.
  • Drag the table into the LU Schema window from the DB Objects tab.

From the Project Tree:

  • Via the Auto Discovery Wizard to create or edit the LU. The tables and their populations are automatically created and added to the LU schema. If a table exists, you can select to either override the existing implementation or not.
  • Creating a new table manually. In this option the table population should be created separately. Once the population is created, add the table to the LU schema. Note that if the table is used as the Master of Data, there is no need to create a Table Population.
  • Copying an existing LU table from one LU to another. In this option if there is a Table Population it is also copied.
  • Creating a set of tables based on an XSD file.
  • Using the Save As option. Note that this option does not copy the Table Population.

Click for More Information about Adding a Table to a Schema.

How Do I Create a New LU Table Manually?

  1. Go to Project Tree > Logical Units > [LU Name], right click Tables > New Table to display the Columns tab in the Table Schema window.
  2. Define the Table Schema:
    • Complete the settings of each table column like the Name or Data Type.
    • Optional: Define the table Indexes.
    • Optional: Define the CDC and the table’s Search indexes.
  3. Define the Table Properties.
  4. Save the table.

How Do I Edit an LU Table?

  1. Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Columns tab in the Table Schema window.
  2. Optional: Edit the table’s Columns, Indexes, Search Indexes or Table Properties.
  3. Save the table.

Note that in specific cases the Data Type of a column that has been automatically created based on a DB table may need to be edited manually. For example, a Number column in Oracle is created in Fabric with Data Type = Real. This column might need to be modified to an Integer or Text in the LU table.

Table Schema Definition

The LU Table Schema is defined in the Columns Tab in the Table window where you can set the columns and their types, mark mandatory fields and set the default values.

Index

Defines the position of the column in the table which can be moved up or down.

Name

Column name.

Data Type

The Data Type of the values in the column. The following types are supported:

  • Integer
  • Real
  • Text
  • Blob

Note that if the Oracle field type is Number, Fabric sets the Data Type of this field to Real in the LU table and the number in Fabric has a decimal point. Therefore, if a column in the LU table does not need a decimal point (for example, for the CUSTOMER ID), change the Data Type of the LU Table column to Integer or Text.

Mandatory

When checked, this column must be populated (not null), otherwise leave it unchecked.

Default Value

The value set in this column is used to populate the table when there is no input for this column.

Column Type

Two Column Types are supported:

  • Regular, (default) whereby the column is populated using the table’s mapping.
  • Computed field, whereby the column is updated using an Enrichment function.

The difference between the Column Types is the timing of their execution. When a column is defined as a Computed Column, the execution of the function is performed after all tables in the Logical Unit have been populated.

Comment

Additional information.

ID

Unique ID of the column generated by Fabric.

 

Previous

Create an LU Table

How Do I Create a New LU Table?

LU tables are the basic building blocks for creating Logical Units. There are several ways to create a new LU table.

From the LU schema:

  • Right click the work area and select either the New Table From SQL Based DB Query or New Table From SQL Based Root Function option.
  • Drag the table into the LU Schema window from the DB Objects tab.

From the Project Tree:

  • Via the Auto Discovery Wizard to create or edit the LU. The tables and their populations are automatically created and added to the LU schema. If a table exists, you can select to either override the existing implementation or not.
  • Creating a new table manually. In this option the table population should be created separately. Once the population is created, add the table to the LU schema. Note that if the table is used as the Master of Data, there is no need to create a Table Population.
  • Copying an existing LU table from one LU to another. In this option if there is a Table Population it is also copied.
  • Creating a set of tables based on an XSD file.
  • Using the Save As option. Note that this option does not copy the Table Population.

Click for More Information about Adding a Table to a Schema.

How Do I Create a New LU Table Manually?

  1. Go to Project Tree > Logical Units > [LU Name], right click Tables > New Table to display the Columns tab in the Table Schema window.
  2. Define the Table Schema:
    • Complete the settings of each table column like the Name or Data Type.
    • Optional: Define the table Indexes.
    • Optional: Define the CDC and the table’s Search indexes.
  3. Define the Table Properties.
  4. Save the table.

How Do I Edit an LU Table?

  1. Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Columns tab in the Table Schema window.
  2. Optional: Edit the table’s Columns, Indexes, Search Indexes or Table Properties.
  3. Save the table.

Note that in specific cases the Data Type of a column that has been automatically created based on a DB table may need to be edited manually. For example, a Number column in Oracle is created in Fabric with Data Type = Real. This column might need to be modified to an Integer or Text in the LU table.

Table Schema Definition

The LU Table Schema is defined in the Columns Tab in the Table window where you can set the columns and their types, mark mandatory fields and set the default values.

Index

Defines the position of the column in the table which can be moved up or down.

Name

Column name.

Data Type

The Data Type of the values in the column. The following types are supported:

  • Integer
  • Real
  • Text
  • Blob

Note that if the Oracle field type is Number, Fabric sets the Data Type of this field to Real in the LU table and the number in Fabric has a decimal point. Therefore, if a column in the LU table does not need a decimal point (for example, for the CUSTOMER ID), change the Data Type of the LU Table column to Integer or Text.

Mandatory

When checked, this column must be populated (not null), otherwise leave it unchecked.

Default Value

The value set in this column is used to populate the table when there is no input for this column.

Column Type

Two Column Types are supported:

  • Regular, (default) whereby the column is populated using the table’s mapping.
  • Computed field, whereby the column is updated using an Enrichment function.

The difference between the Column Types is the timing of their execution. When a column is defined as a Computed Column, the execution of the function is performed after all tables in the Logical Unit have been populated.

Comment

Additional information.

ID

Unique ID of the column generated by Fabric.

 

Previous