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

 

Customer Loyalty Programs

 

A Free License for IT Professionals

Send us a link to your profile and get a free license for any ETL product!

suit up
Promote our ETL Software

You can get a significant discount, and even a free license, by spreading a word about our ETL Software.

chat
Competitive Upgrades

Get 50% OFF for switching to our ETL Software from competing tools!

money

Go to top