Can someone tell me how publish and subscribe work? We have a vendor who
is trying to set up multiple servers with multiple databases that will
update a data warehouse. He says that, by using publish and subscribe,
he can update the tables without duplicates, even though one person may
be entered on one system with a different address, etc. than on another
system. This seems a little backward to me, and that one central server
database with all clients accessing that information more efficient and
safer. Any advice?