Entities tab - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

The Entities tab enables you to configure the entities that will be included in your model. These entities represent objects or events, which may have properties associated with them, and these properties can be stored in your model as well if you choose to include it. Entities are linked to each other by relationships, which you establish on the Relationships tab.

After you configure settings on this tab, click the Relationships tab to continue creating your model.

Model
Specifies the name of the model.
ID
Select the ID that you want in this drop-down list to use to generate entities for the model.
Type in separate field
If the entity type is in its own field, select this check box and select the field in the Type drop-down list.
Field Name
This grid includes all the fields from your entity input file. Select the fields whose data you want included in the model by clicking the Include box for those fields.
Select which fields you want to be indexed in your model by clicking the Index box for those fields. Selecting which fields to index, rather than indexing all fields in your model, results in faster performance when writing to a model. However, if you later attempt to query fields in your model that were not indexed, the response time will be slower. You can query non-indexed properties using conditions, but the performance will be slower.
In the Index Type column, you can choose whether the data should be indexed with or without case sensitivity. Selecting Case Insensitivity typically results in more results from a search. You cannot change the Index Type for an existing property unless the entity it is associated with contains zero counts. For example, if an Entity Person contains two properties, Name and DateOfBirth, and person contains counts, you cannot change the Index Type for either property, even if one of the properties contains zero counts.