Data cleansing

[sri75]

Hi,


I have some questions regarding Ascential Integrity Tool.

I think it is used for cleansing data.Could anybody please tell exactly how it works ?How to clean data in the text files using ths toll.

Thanks
Sri

[ray.wurlod]

Ascential bought the company called Vality that wrote the tool called INTEGRITY. That tool has now been incorporated into the Ascential product suite and is called QualityStage.

There are essentially four phases to data cleansing:

• investigation (find out what's there, which can be character-based, word-based or can even look at overlapping/redefined fields)
  
  standardization (correctly "bucket" data according to rule sets)
  
  matching (various kinds, to determine what blocks (groups) of potential duplicates there are)
  
  survivorship (to yield the "best of breed" data, again you can specify how, e.g. longest string, most recent, highest information content weight)

For more information look on the Ascential web site and/or enrol in the QualityStage training class.