Transformations - 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

This feature gives you the flexibility of transforming a value before populating it to a column in a logical model entity. The values are sourced from the columns of physical model tables.

On the basis of the functions you need to apply on values before populating the logical model columns, you can do transformation on:
  • Columns: To populate values from a column of a physical model table
  • Constant: To apply a constant value to a logical model column or to one of the parameters of a function transformation
  • Function: To apply functions of string, numeric, conversion, and datetime to a logical model column, or to one of the parameters of a function transformation.

You can create complex nested transformations within the parent transformation.