Data Cleansing

In the course of doing business, the data in your databases may not be recorded completely accurately. Aruna can help clean your data by performing these tasks on your databases.

• fix data that has been recorded inconsistently (data reconciliation), often from the use of abbreviations or other shortcuts
• find data that is in the wrong column
• find encoded data that is mixed with free text data

After data cleaning, your old queries will still run without the need for any modification.

The table below provides an example of the data reconciliation that Aruna can do.

Reconciled ID Numbers