Menu Bar
  Aruna Logo
 
solution menu bars

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

  DATABASE A DATABASE B
Clean Join P/ E1P050414 P/ E1P050414
Extra letters L/ E5FI00532_ P L/ E5FI00532
Incomplete 422 L/ E0100422
Range L/ E1P033601-12 L/ E1P033608
Range L/ E01047463+ 4 L/ E01047465
List L/ E1X032118,19,24,32 L/ E1X032124


Copyright 2005 Aruna Solutions, Inc.

home products solutions news about partners customers contact default solutions revenue assurance data cleansing customer management business intelligence data integration default