This is a master-detail list. The left-side table shows one row for each load 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 loading metadata from your source system.|
|Description||The free-format description you assigned when loading metadata from your source system.|
|Source||The name of the data source from which this table will be loaded to the data warehouse.|
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.|
|Columns||Show the Column List for the selected table, to support column editing.|
|Scripts||Show the Table Scripts form for the selected table, to review and test generated ELT scripts.|
|Create Stage||Create a staging table to transform the selected load table, moving the data to facts and dimensions.|
|View Data||View a sample of data from the selected table, using the Table View form.|