MDM Import Manager - Join source tables

[Former Member]

We have the following table scheme in our products database which we would like to join using MDM Import manager:

 _______	 _____________		 ______________
|tblPart|	|tblPartRegion|		|tblRegion     |
|_______|   	|_____________|		|______________|
|PartID	|------>|PartkFK      |	   |----|tblRegionId   |
|...	|	|PartRegionID |	   |	|tboReigionName|     
|_______|	|RegionFK     |<---|	|______________|
		|_____________|

The result should map tblPart (key in MDM destination) to 1-n regions (Region is multi-select look-up in MDM destination). I have already read <i>How To.. Handle Attributes during Data Transformation</i>, and the only option given in the document, as I understood, was to perform the join and create another database table. Ideally, I would like to perform this join within Import Manager.

Resulting temp table:

 _____________________
|tblTmpResult         |
|_______ _____________|
|Part   |Region       |
|_______|_____________|
|part1  |North America|
|part1  |Europe       |
|part2  |Europe       |
|part3  |South America|
|part4  |Asia         |
|part4  |North America|
|_____________________|

[Former Member]

In the Import Manager,

choose tblPart as the Source Table.

Once you have chosen the tblPart as the source table, right click on PartID field.

Join via this field to the table tblPartRegion. Choose PartkPF as the joining field.

Now change the source table to tblPartRegion.

Join the RegionFK field to tblRegionId field of tblRegion table.

Now again change the source table to tblPart.

Now you will see the looked up tables beneath the tblPart table as sub nodes.

Choose the PartRegionId as the Lookup field of table tblPartRegion.

Choose tboRegionName as the Lookup field of table tblRegion.

Now choose the table tblPart(Lookup) in the source preview.

You will see the new extended table values with the joins.

If you need further reference, please refer to the Import Manager Reference guide.

Hope this helps.