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
It is also possible to enter the data directly into source grid and test it the transformation that way