Skip to main content

Viewing missing references

ON THIS PAGE

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 for Data Warehouses. Either via the Monitor tab in the Manage ETL Sets window or by switching the console to Monitor view and selecting the Missing References tab. The instructions below cover both of these methods.

  1. Click the Manage button in the lower left corner of the Storage Zone panel.
  2. Select the desired ETL set in the left side of the Manage ETL Sets window.
  3. Switch to Monitor view by clicking the Monitor tab in the top right of the Manage ETL Sets window.
  4. Click the View Missing References toolbar button. The Missing References - <ETL Set Name> window opens.

    The following information is displayed:

    • General information: The run number of the ETL 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.
  1. Switch the console to Monitor View.
  2. Select the desired Storage Zone ETL task.
  3. Click the Missing References tab below the task list.

    The following information is displayed:

    • General information: The run number of the ETL 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:

Example table content
Missing Records from Entity Referenced from Entity Via Relationship

Customers (2)

Orders (8)

Customers

-

Disputes (4)

CustomerDisputes

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

Example table content
Key Referenced from Entity Via Relationship

Mr. Brown

Orders (7)

Customers

-

Disputes (4)

CustomerDisputes

Mr. Smith

Orders (1)

Customers

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