Derive VAL

The Derive transformation requires the free-form transformation be specified as a formula using the following operators, arguments, and functions: +, -, **, *, /, %, (, ), x, y, z, abs, exp, ln, log, sqrt. When the delay query is off, the input table be transformed immediately otherwise the result should be combined with other transformations and fed into a final Transform function.

Options

Arguments Columns
FillNA Value
Formula
Specifies the free-form transformation required for Derive. E.g. x+y+z (in which case 3 key columns are selected).
Key Columns
Nullstyle
Output Column Name
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
The dataset containing the raw information that we will perform a Derive VALIB function call

Output Ports

Icon
Derive VAL output

Nodes

Extensions

Links