This section is shown below the Attribute Columns section. It contains the following:
It is used to define the simple join between the table into which data is to be loaded and an existing reference table. The section consists of Join Details and Join Key Pairs sub-sections.
The Join Details sub-section contains the following:
•Create new join after load: this checkbox is unchecked by default. When checked, a join between an existing reference table and the uploaded data's table will be created when the data is loaded. Checking the property enables Reference table.
•Reference table: this property is mandatory when enabled. It represents the existing database table to which the uploaded data's table will be joined. It is populated using the Choose Database Item dialog, which lists all tables in the data warehouse. On changing the selected table:
o Any existing join key pairs are removed.
o A new join key pair is added, following the rules documented at the Join Key Pairs table’s Add button (see below for details).
•Cardinality: this dropdown list allows you to define the nature of the join between the reference and data tables. It exposes the following values:
o Not known (the default)
o One to one
o One to many
o Many to one
o Many to many
The Join Key Pairs sub-section allows you to define the pairs of keys that will be used to create the join between reference and data tables. It consists of a toolbar and a table.
•Toolbar: exposing the following:
o Add: this button is enabled when a Reference table has been chosen. Clicking it adds a new join key pair to the table. Join Key 1 is set to the data table's primary key (or first alphabetical column if a primary key is not defined). Join Key 2 is set to a matching column at the reference table, else to its primary key, else to the first column alphabetically.
o Remove: this button is enabled when a join key pair is selected. Invocation removes the currently-selected join key pair without display of an ‘Are You Sure?’ dialog.
•Table: listing all existing join key pairs. The table contains two columns:
o Join Key 1: this column represents a key from the data table. It is set using a dropdown, which exposes values representing each of the data table's columns.
o Join Key 2: this column represents a key from the reference table. It is set using the Choose Database Item dialog, which is constrained to display only columns from the selected Reference table.
Provision of at least one join key pair is mandatory.