Built-in Functions

Over 300 built-in functions, covering such topics as maths functions, string manipulation, date conversions, transaction handling, database tuning, data cleansing and reconciliation, are included to provide an extremely powerful transformation development environment.

The diagram above shows some of the categorised functions available. These are all provided with in depth online help including examples, and can be added to the transformation by double clicking or simply dragging and dropping.