Data Transforms
Data transforms are used to manipulate data.
An integration allows you to have any number of data manipulations, depending on the task at hand. Numerous transformations can be chained together to perform complex data manipulation, while simple integrations may only use one or two. It is also possible to create an integration with no data transforms at all, though the need for this is extremely rare.
IMan currently has seven transforms, which can be split into three categories:
- Shape the data in / out of hierarchical structure using the Hierarchy / Flatten Transforms respectively.
- Record level manipulation of data, with Translate, Sort, and Filter.
- Field level manipulation of data (using VBScript to carry out the manipulation), through Aggregate and Map.
Level of Manipulation
Data can be handled at field or record level. Field level manipulation means the transform can affect values in individual fields. Whereas at record level, such as with the Filter transform, the entire record is transformed.