Viewing missing references

In some cases, incoming data is dependent on or refers to other data. If the referenced data cannot be loaded for some reason, you can either decide to add the data manually or continue on the assumption that the data will arrive before it is needed.

There are two ways you can view missing references in Compose. Either via the Monitor tab in the Manage Data Warehouse Tasks window or by switching the console to Monitor view and selecting the Missing References tab. The instructions below cover both of these methods.

To check for missing references in the Manage Data Warehouse Tasks window:

1. Click the Manage button in the lower left corner of the Data Warehouse panel.
2. Select the desired task in the left side of the Manage Data Warehouse Tasks window.
3. Switch to Monitor view by clicking the Monitor tab in the top right of the Manage Data Warehouse Tasks window.

4. Click the View Missing References toolbar button. The Missing References - <task Name> window opens.

   The following information is displayed:

   • General information: The run number of the task, when it started and ended, the total number of inserts and updates, and the number of reported rows (if any).

   • Missing references information:

     • Missing Records from Entity - The name of the entity with missing reference and the number of missing references.

       To see the missing record keys for the entity, click the number in parentheses to the right of the entity name.

       The Missing Record Keys for Entity - <Entity Name> window opens showing the list of missing keys and the number of times each key is referenced per entity.

     • Referenced from Entity - The entities that are referencing the entity with missing references.
     • Via Relationship - The name of the relationship in the Model.
5. To close the window, click Close.

To check for missing references in the Compose Monitor:

1. Switch the console to Monitor View.
2. Select the desired task.

3. Click the Missing References tab below the task list.

   The following information is displayed:

   • General information: The run number of the task, when it started and ended, the total number of inserts and updates, and the number of reported rows (if any).

   • Missing references information:

     • Missing Records from Entity - The name of the entity with missing reference and the number of missing references.

       To see the missing record keys for the entity, click the number in parentheses to the right of the entity name.

       The Missing Record Keys for Entity - <Entity Name> window opens showing the list of missing keys and the number of times each key is referenced per entity.

     • Referenced from Entity - The entities that are referencing the entity with missing references.
     • Via Relationship - The name of the relationship in the Model.
4. To close the window, click Close.

Missing references example

In the following example, Orders and Disputes both reference Customers.

Orders contains seven records pointing to Mr. Brown and one record pointing to Mr. Smith. Disputes contains four records referencing Mr. Brown. Mr. Brown and Mr. Smith are "missing" from Customers.

The would be reflected as follows:

Clicking the number to the right of Customers (in the Missing Records from Entity column) would open the following window:

See also: How Compose handles missing references in the data warehouse.