Advanced ETL Processor has a lot of useful features designed to make the life of Business intelligence consultants easier. One of it 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 data sample we want to check if 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 source grid and test it the transformation that way

Mapping Result success

Learn MoreDownloadBuy Now

We have 124 guests and no members online