This is a master-detail list. The left-side table shows one row for each stage table you have defined. The right-side table shows one row for each column in the selected left-side table.
The list context menu shows actions you can take that affect the row table.
Master List Columns
|Table Name||The name of the table you assigned when creating this stage table.|
|Business Name||The free-format description you assigned when loading metadata from your source system. This value will be used for business metadata generation.|
Detail List Columns
|Column Name||The name of the each column in the selected table.|
|Data Type||The Ajilius data type which will be used to store data for this column.|
|Role||Role that this column plays in defining database structure and processing. See Column Roles.|
|Change Table||Change the table name, description, documentation, etc. using the Table Edit form.|
|Delete Table||Delete the table definition using the Table Edit form.|
|Unlink Table||Break the connection between a Stage table and its predecessor From table, to enable new transforms to be inserted in the flow. Columns are left in place in the Stage table, but must be remapped from the Column List when the new transforms are in place.|
|Columns||Show the Column List for the selected table, to support column editing.|
|Joins||Show the Join List for the selected table, to add one or more tables to the join set.
This menu option will only be available for SELECT / JOIN transformations.
|Unions||Show the Union List for the selected table, to add one or more tables to the UNION set.
This menu option will only be available for UNION / UNION ALL transformations.
|Where||Show the Where Clause editor for the selected table, to add filtering conditions to the transformation query.
This menu option will only be available for SELECT, DEDUP and GROUP BY transformations.
|Scripts||Show the Table Scripts form for the selected table, to review and test generated ELT scripts.|
|Create Stage||Create another staging table to further transform the selected table.|
|Create Dimension||Create a dimension table from the selected staging table.|
|Create Fact||Create a fact table from the selected staging table.|
|View Data||View a sample of data from the selected table, using the Table View form.|