NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

Addressing Data Quality Issues

Everyone who performs data transformation knows the importance of data quality and how much time is required to find what went wrong and correct the problem

In the latest version of Advanced ETL Processor we introduced new object called "Log"

Data Quality LogThe idea is very simple: to redirect log messages into different data flow so this data can used later for reporting.

Plus comparing to standard text log it provides much more information to the user.

It allows to answer the following questions:

What was wrong with the data?
Which actions were taken to correct the data?
Initial value of the field
Value after correction
Source file/table
Record number
Date
Computer name
User name
Customer Name
Person responsible
Date
And much more

We would like to thank Adrian Parker from Differentia Consulting Ltd for giving us useful feedback

Visit Support Forum Learn More Download Buy It

Advanced ETL Processor's ability to validate and tranform data without actually loading it into the datawarehouse has saved us a lot of time. We were able to see how data will look like, once it is transformed and which records would fail during data validation.

Antony Clark,
RBS 

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with