Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abgaur
Starting Member
1 Post |
 Posted - 2009-11-15 : 15:35:02
|
| 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 |
|
|
smeeluv
Starting Member
20 Posts |
Posted - 2009-11-20 : 12:47:36
|
| I think you need to setup relationship tables at both of the offices. If you say that +A vendor sends the exact same products to two different offices, then the vendor is sending their item id's as well. Then you need to create a table for each office that shows office item no and vendor item no. From there you can join your data from the two offices by vendor item no. |
 |
|
|
|
|
|
Data Cleansing/Scrubbing Technique