Mapping Multiple Inputs to the Output Schema - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

If you create a project with multiple input entities, only one of the entities will be mapped to the output schema in the Schema Editor. For example, if you have two input entities, Usinput(34) and Upinput2(182), only the attributes of the first input, Usinput (34), are initially mapped to the output.

Therefore all other input entities must be mapped to this output schema. There are two ways to do this. Both methods can be used for single or multiple input entities.

Guidelines:
  • If you use an output entity from a Quality process as input to your project, do not insert the system-defined attributes Source ID and Sequence Number into your output schema. These attributes are automatically generated in the output schema and should not be duplicated.
  • Be careful of the order of mapping for the following scenario: Input 1 has attributes A and B, Input 2 has attribute A and you want to create an output attribute C that contains B from Input 1 and A from Input 2. The results will be the same in both batch and the Control Center, as long as you map A before B (and give them both the length of the longer attribute), so that A from Input 1 is overwritten by B from Input 1. If you map B before A then, in the batch output, B from Input 1 will be overwritten by A from Input 1. The problem does not occur in the Control Center because the attribute names include the entity number but in batch the entity numbers are removed.

Method 1: Insert input attributes into output

One way of mapping is to insert the attributes in the output schema.

  1. Click the arrow next to the entity name ( ) and select another entity from the drop-down list. The input attributes of this entity are displayed in the left pane.
  2. Drag and drop each input attribute from the entity to a position in the output attribute list. You must position the cursor so that there is a horizontal line at the required insertion point. You can select multiple attributes to drag.

    In this example, attributes from the second input entity, Usinput2(182), were inserted into the output. Name was inserted after Line 01, Street was inserted after Line 02, and City was inserted after Line 03.

  3. From the Navigation or Project View, right-click the process and select Apply Schema Changes.
  4. When the message box appears, click OK.

Method 2: Redefine input attributes to output as sub-attributes

The other way of mapping is to redefine the attributes as sub-attributes (synonyms)

  1. Click the arrow next to the entity name ( ) and select another entity from the drop-down list. The input attributes of this entity are displayed in the left pane.
  2. Drag and drop each input attribute from the entity on top of the output attribute. You must position the cursor so that there is a box around the output attribute to which you are mapping this input. You can select multiple attributes to drag.

    In this example, Name was copied to Line 01, Street was copied to Line 02, and City was copied to Line 03 from the second entity, Usinput2 (182). The width of the output attributes will be adjusted automatically.

  3. From the Navigation or Project View, right-click the process and select Apply Schema Changes.
  4. When the message box appears, click OK.
    Note: By default, when you redefine an output attribute by drag-and-drop, the sub-attributes will not be displayed in the attribute selection lists in the Control Center. If you need to display the sub-attributes in the lists, see Displaying Mapped Sub-attributes.