Navigate to the Objects tab.

This is an overview of all the objects in this source. Here you can change some properties of the objects such as short names, whether the table is multi active or not, etc.

You can also click the

button to turn the build flag for this table off such that it will not be included in your data vault.

Some objects may appear red in this overview. This indicates there is a problem with the object that needs to be fixed before you can proceed. One example is that the table has no primary key. The reason for this could be that this table only contains information about a relationship between other tables; such a table is modeled by a direct link. A direct link table always requires at least two foreign keys.

Double click a table row to edit and change its properties, e.g. set the Object type to “Direct Link”.

Another object type is the reference table (non-historized for now). This table will essentially just be copied as is to the data vault.

Clicking on an object also shows some additional buttons.

Click

to change some parameters for this object.

The

button shows all the attributes for this object, here, you can define which attributes are Business keys or Universal Identifiers (such as ISBN numbers for books). The

can again be used to exclude a column from your data vault. The Historic Attribute flag determines whether the changes to this attribute should be tracked or not.

If you have set the “DATA_QUALITY_BAD” parameter to “Y” for this source, you can also edit the Data types of your attributes (especially useful for flat file sources). Otherwise you can only adjust the Data Length, Scale and Precision. In the Format mask column, you can define the format of the column, this is mainly for dates (day month order, separating character etc) and times but is also available for numbers. If this is not filled in, the default as defined in the parameters will be used.

In addition, you can also add new relations or disable existing ones. Click on

If you want to add a primary or unique key, click the

button.

Here you can choose the columns of the constraint, the constraint type and a name (if the name is empty one will be generated). To add foreign key constraints, click the

button. Choose the target table from the drop-down menu.

and press the

button.

Drag and drop an arrow between the columns you wish to connect. You will be asked to fill in a name for the new relation, or you can leave it blank and a name will be generated automatically. When done, you will see an arrow connect the two objects.

Click on the

to view all the relations.