Maurice,
I work in the Ministry of Defence where we have millions of items of inventory which need to be purified over the next few years as we rationalise our business and IT.
There are many companies out there who say that they can cleanse data but you need to be very clear what it is you really want? Ideally you need to check the data against the business requirement.
I have heard of small companies using MS Excel to be able to identify uplicates and triplicates since it will list in numerical order.
Specialist software does not come cheap and you need to know how to use it. I think the software that our particular group uses is called Trillium but it only identifies those data elements that do not conform to the requirement. The hard graft still has to be done by the business experts who actually own (= purchase and manage) the items and associated data.
This is probably not much help but you id not give me much to go on in your message.
Nigel Billington (01264 383833)(nigel.billington381@mod.uk)
.
