Transformation

An overview of all transformations in ETLBox

This article will give you an overview of all transformations that currently exist in ETLBox. If you already know what kind of transformation you are looking for, you can visit directly the article that goes more into the details.

Details about the CachedRowTransformation

The CachedRowTransformation does basically the same as the RowTransformation, but has a cache to access previously processed data rows.

Details about the ColumnRename

This transformation let you rename the properties names of your ingoing data. Also, you can remove columns from your flow.

Details about the Distinct transformation

The Distinct transformation will filter out duplicate records.

Details about the FilterTransformation

The FilterTransformation filters out row that do not match with a given predicate.

Details about the LookupTransformation

If you want to lookup some data from existing tables or other sources, the lookup transformation is the right choice. It allows you to enrich the incoming rows with data from the lookup source.

Details about the MergeJoin

The MergeJoin transformation joins the outcome of two sources or transformations into one data record. This allows you to merge the data of two inputs into one output.

Details about the Multicast

The Multicast is a component which basically clones your data and send them to all connected target. It has one input and can have two or more outputs.

Details about the RowDuplication

The RowDuplication simply creates duplicates of the incoming rows. You can specify how many copies you want or if you want to create a copy only if a predicate evaluates to true.

Details about the RowMultiplication

The RowMultiplication allows to create multiple records out of one input record. It works like a RowTransformation - so it accepts an input and an output type - but instead of just modifying one records it can return an array of records (when you return an empty list, it will even remove the incoming row).

Details about the RowTransformation

The RowTransformation will apply a custom transformation function to each row of incoming data. This transformation is useful in many scenarios, as it allows you to apply any .NET code to your data.

Details about the XmlSchemaValidation

This transformation allows you to validate XML code in your incoming data against a XML schema definition.