Applying a Column Transformation - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
A column transformation allows you to link the required column of a physical model table to define an attribute of a logical entity or one of the parameters of a function transformation. You can do a column transformation by using the Transformations panel as described below or by linking a physical model column with an attribute in a logical entity directly on the canvas.
  1. On the Create Mapping <logical model name> page, select the entity corresponding to the attribute to which you want the transformed value applied, and click the Transformations collapsible tab on the right side of the page.
    The Transformations panel is displayed showing the name of all the attributes in the selected entity. The Transformation column remains blank initially. It displays the transformation type after you save the transformation.
    Note: The Transformation panel doesn't display details of the physical model table. In case you click a physical model table after an entity and open the Transformation panel, it displays details of the last selected entity.
  2. Select the attribute to which you want the transformed value applied, and click the Transformation icon .
    The Transformation of column '<column name>' pop-up window is displayed.
  3. Select the Column option, and from the Physical Model Name drop-down list, select the required physical model.
  4. From the Table Name drop-down list, select the required table.
  5. From the Column Name drop-down list, select the required column that you want to map with the attribute.
  6. Click OK.
    The selected column gets mapped with the attribute and it is indicated by a connecting arrow between the two on the canvas. The Transformation panel displays this as a Simple transformation.
    Note: The data type of the attribute is inherited from the mapped physical model column.