Target Design

Set Target Dependencies

Dependencies are used to document the order of execution across Process Areas and objects within the Wave. Dependencies are set for Target tables that have a relationship with one or more Target tables.

Tables can have parent and child dependency relationships that are defined in Target Design.

For example, if Target A is the parent of Target B, data from a field in Target A must be populated for a corresponding field in Target B. In this case, Target B has a child dependency with Target A. The fields that are used in the dependency are defined on the Target Dependency Relationship page.

Dependencies are set at the child level. In other words, the selected Target’s dependency is set in relation to its parent. If the selected Target is the parent of Target C, this relationship is set for Target C.

View the dependencies for a Target on the Target Dependency (Children) and the Target Dependency (Parents) pages (Design > Targets > Vertical View).

NOTE: All Targets across all Waves and Process Areas are available for use in a dependency.

NOTE: If a Target field is used in a relationship, the field and the Target cannot be deleted.

After a Target dependency relationship has been established, field dependencies must be added for key fields. These dependencies are then synced with Map.

To set a parent dependency for a Target table:

  1. Select Design in the Context bar.
  2. Click the Targets icon on the Design page.
  3. Click the Dependencies icon for a Target.
  4. If no records exist, the page displays in add mode. Otherwise, click Add.

    View the field descriptions for the Target Dependencies page

  5. Select the table name from the PARENT TARGET ID list box.

    NOTE: All Targets across all Waves and Process Areas are available.

    NOTE: Multiple relationships can be set for the same parent table (as in, multiple fields in the parent table can have a dependency with fields in child table(s)).

  6. Click Save.
  7. Click the Relationships icon.
  8. If no records exist, the page displays in add mode. Otherwise, click Add.

    View the field descriptions for the Target Dependency Relationship page

  9. Select a field name in the PARENT FIELD list box.

    NOTE: All fields in the parent table, active and inactive, display in this list.

  10. Select a field name in the CHILD FIELD list box.

    NOTE: All fields in the child table, active and inactive, display in this list.

  11. Enter a description or notes about the relationship in the DESCRIPTION field.
  12. Click Save.
  13. Navigate to the Target Dependencies page.
  14. Click the Find Dependencies icon on the Page toolbar.
  15. Select the dependency.
  16. Click Add.

When the Target is next synced with Map, the dependency is added.