I have to create a single dimension table from three different sources.The master "Vendor" list exists independently in all 3 sources with different key values and attribute set. The Vendor names although similar may not match exactly.
What is the most elegant/low maintenance way of consolidating data into single dimension table.
Thanks
What is the most elegant/low maintenance way of consolidating data into single dimension table.
Thanks