Advanced ETL Processor has a lot of useful features designed to make the life of Business intelligence consultants easier. One of them is "Magic Button". At any time the user can press it and see the result of data transformation or validation without actually loading the data.

Here is a data sample we want to check if the customer id is numeric and reject it if not

Source data Here is the mapping we will use for it.

Mapping ExampleIs Number transformation functionWe press the "Magic Button"

Magic buttonAnd we can immediately see the result of transformation: record rejected 


Mapping Result failure

record passed the test Mapping Result success

It is also possible to enter the data directly into the source grid and test it the transformation that way

Mapping Result success

Direct link, no registration required.