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 , the New Table From SQL Based Root Function or the New Table From SQL Based Broadway Flow 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?
- Go to Project Tree > Logical Units > [LU Name], right click Tables > New Table to display the Columns tab in the Table Schema window.
- 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.
- Define the Table Properties.
- Save the table.
How Do I Edit an LU Table?
- Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Columns tab in the Table Schema window.
- Optional: Edit the table’s Columns, Indexes, Search Indexes or Table Properties.
- 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.
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 , the New Table From SQL Based Root Function or the New Table From SQL Based Broadway Flow 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?
- Go to Project Tree > Logical Units > [LU Name], right click Tables > New Table to display the Columns tab in the Table Schema window.
- 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.
- Define the Table Properties.
- Save the table.
How Do I Edit an LU Table?
- Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Columns tab in the Table Schema window.
- Optional: Edit the table’s Columns, Indexes, Search Indexes or Table Properties.
- 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.
