LU tables are the basic building blocks for creating Logical Units. There are several ways to create a new LU table.
There are 3 main methods for creating a new LU table:
From the LU schema:
Right-click on the working 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.
From the Project Tree:
Use the Auto Discovery Wizard to either create or edit the LU. The tables and their populations are automatically created and added to the LU schema. If a table already exists, it is possible to override the existing implementation.
Create a new table manually. In this option, the table population should be created separately. Once the population has been created, add the table to the LU schema. Note that if the table is used as the master data, there is no need to create the table population.
Create a table based on data source table, using the DB Interface Explorer:
Switch from the Project Tree to the DB Interface Explorer by clicking the icon on the left Activity Bar.
Click on the relevant interface data source and select the required table.
Right-click on the table and choose "Add Tables to Schema". The table will be created in Fabric according to the selected table definitions, along with its population, and will be added to the schema.
Note that you can expand the table in the DB Interface Explorer and select specific columns. By doing so, the created Fabric table will contain only the columns that were selected.
Create a table based on data source tables, using the Query Builder:
Click for More Information about Adding a Table to a Schema.
From the Project Tree:
From the Project Tree:
A new table is created along with a duplicated table population flow.
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 manually edited. For example, a Number column in Oracle is created in Fabric with Data Type = Real. This column may need to be modified to either an Integer or a Text in the LU table.
While creating or editing an LU table, you can set the columns and their types, mark mandatory fields and set the default values.
LU tables are the basic building blocks for creating Logical Units. There are several ways to create a new LU table.
There are 3 main methods for creating a new LU table:
From the LU schema:
Right-click on the working 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.
From the Project Tree:
Use the Auto Discovery Wizard to either create or edit the LU. The tables and their populations are automatically created and added to the LU schema. If a table already exists, it is possible to override the existing implementation.
Create a new table manually. In this option, the table population should be created separately. Once the population has been created, add the table to the LU schema. Note that if the table is used as the master data, there is no need to create the table population.
Create a table based on data source table, using the DB Interface Explorer:
Switch from the Project Tree to the DB Interface Explorer by clicking the icon on the left Activity Bar.
Click on the relevant interface data source and select the required table.
Right-click on the table and choose "Add Tables to Schema". The table will be created in Fabric according to the selected table definitions, along with its population, and will be added to the schema.
Note that you can expand the table in the DB Interface Explorer and select specific columns. By doing so, the created Fabric table will contain only the columns that were selected.
Create a table based on data source tables, using the Query Builder:
Click for More Information about Adding a Table to a Schema.
From the Project Tree:
From the Project Tree:
A new table is created along with a duplicated table population flow.
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 manually edited. For example, a Number column in Oracle is created in Fabric with Data Type = Real. This column may need to be modified to either an Integer or a Text in the LU table.
While creating or editing an LU table, you can set the columns and their types, mark mandatory fields and set the default values.