Delete from Model Options - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
Copyright
2024
First publish date
2007
Last updated
2024-10-11
Published on
2024-10-11T22:55:47.128293

Options for this stage configure elements to be removed from a model.

Model

Specifies the model from which to delete entities or relationships. The model can be written to simultaneously by multiple Context Graph stages.

Delete entities

Select this check box to remove entities from the model.

ID
In this box, select the field that contains the entities you want to remove from your model. This is often, but not always, the _stp_id field if the ID and type are together, or the _stp_label field if the ID and type are separate.
  • In ID field—Choose this option if the input data stores the entity type with the ID, such as with _stp_id.
  • In separate field—Choose this option if the input data stores the entity type separately, such as with _stp_label, and select the appropriate field in the Type box. This is often, but not always, the _stp_type field.
  • Literal—Choose this option to select a specific entity type, and select the appropriate field in the Type box.

Delete relationships

Select this check box to remove relationships from the model.

Source ID
In this box, select the field that contains the source entities. This is often _stp_id or _stp_label.
For Type is, choose one of the following options.
  • In ID field—Choose this option if the input data stores the source entity type with the ID, such as with _stp_id.
  • In separate field—Choose this option if the input data stores the source entity type separately, such as with _stp_label, and select the appropriate field in the Type box. This is often, but not always, the _stp_type field.
  • Literal—Choose this option to select a specific source entity type, and select the appropriate field in the Type box.
Label
In this box, select the field that contains the relationship between the source and target entities.
  • Unique ID in separate box—Select this check box if there are multiple relationships with the same label between the source and target entities, and select the name of the Unique ID.
Target ID
In this box, select the field that contains the target entities. This is often _stp_id or _stp_label.
For Type is, choose one of the following options.
  • In ID field—Choose this option if the input data stores the target entity type with the ID, such as with _stp_id.
  • In separate field—Choose this option if the input data stores the target entity type separately, such as with _stp_id, and select the appropriate field in the Type box. This is often, but not always, the _stp_type field.
  • Literal—Choose this option to select a specific target entity type, and select the appropriate field in the Type box.