Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Configuring output groups and fields

Configuring output groups and fields

You can create and modify output groups and output fields. If the output is relational, you can create multiple output groups. If the output is hierarchical, there is one output group.
After you add incoming fields to an output group, you can modify the fields by clicking on the output field name on the
Hierarchy Processor
tab. You can also add and define output fields manually.
The output field properties that appear depend on the data type.
The following table describes the properties for output fields:
Property
Description
Child Of
The parent field or group that this field belongs to. The name structure describes the group, parent fields, and struct name. For example:
OUTGROUP.Grandparent.Parent.struct_name
Name
The name of the current output group or field.
Type
The data type of the current field. For relational output, you can choose a primitive data type. For hierarchical output, you can choose either a primitive or complex data type.
Precision
The total number of significant digits in the field.
Scale
The number of digits to the right of the decimal point.
Array Element Type
The data type of the current array element.
Array Element Precision
The precision for the current array element. Used when creating the target data.
Array Element Scale
The scale for the current array element. Used when creating the target data.
Struct Name
The struct name for the current struct field.
Element Struct Name
The element struct name for the current array of structs field.
Description
Optional description of the field and its usage.
The following table describes the properties for aggregating output data:
Property
Description
Aggregate Options: Optionally, use this field to aggregate values in an output field array.
Indicates that you want to aggregate output data into the current field.
Output Field
Specify the sibling array with fields to aggregate. The array must be a child of the current output field or group.