Applying a 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 an option from Column, Constant, or Function to define the type of transformation to be applied on the values from the physical model tables.
    OptionDescription
    Column Derive the value from a physical model table column. For more information, see Applying a Column Transformation.
    Constant Define the resulting value as a constant. For more information, see Applying a Constant Transformation.
    Function Define the resulting value using String, Numeric, Conversion, and Datetime functions. For more information, see Applying a Function Transformation.
  4. Define the transformation using either one of the above three options, or a desired combination of any of the three.
  5. Click OK.
    The defined transformation is applied on the attribute and is displayed with an arrow on the canvas. The transformation type is also displayed in the Transformations panel of the Create Mapping page.