Design a dimension with multiple data sources
<p>I am designing a few dimensions with multiple data sources and wonder what other people have done to align the multiple business keys per data source.</p>

<p>My Example:
I have 2 data sources - the Ordering System and the Execution System.  The Ordering system has details about payment and what should happen; the Execution System has details on what actually happened (how long it took etc, who executed on the order).  Data from both systems is need to created a single fact.</p>

<p>In both the Ordering and Execution system they is a Location table.  The business keys from both systems are mapped via an esb .  There are attributes in both systems that make up the complete picture about a single location.  Billing information is in the Ordering system, latitude and longitude are in the Execution system.  And Location Name exists in both systems.</p>

<p>How do you design a SCD accomodate changes from both systems to the dimension?  </p>

<p>We follow a fairly strict Kimball methodology - fyi, but I am open to looking at everyone's solutions.</p>