SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Cleansing/Scrubbing Technique

734656Nov 15 2009 — edited Nov 15 2009

Hi,
Can somebody please provide me pointers/directions as to how to go about performing a data scrubbing activity for the following scenario:

+ A Vendor is supplying the exactly same produc to two offices at two different prices. The two offices maintain different systems and hence, have different ways of coding the item no, item description, vendor product name. Using data from the two offices, we want to determine which products are supplied at different prices. There are hundreds of thousand of different products procured by the two offices from thousand different vendors.

Thanks

Edited by: user7906162 on Nov 15, 2009 12:40 PM