Applying a Constant 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
Overview
Reference
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

A constant transformation allows you to apply a constant value to define an attribute of a logical entity or one of the parameters of a function transformation.

  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 Constant option, and from the Type drop-down list, select the data type of the constant value you want to define.
  4. In the Value field, enter a constant value for the selected data type.
  5. Click OK.
The applied constant transformation is reflected on the canvas with a transformation node and it is indicated as Constant transformation in the Transformation panel.
Note: The Transformation of column '<column name>' pop-up window is displayed when you double-click this node.