XML import to MDM
When I try to import an XML file to MDM, using the Import Manager GUI,
if a node in the XML file has more than one value (the node repeats many times),
Import Manager creates a new table as a source.
Is there a way to have all XML data in one table as a source in the Import Manager?
Michael Theis replied
how does your MDM repository look like? I'd expect something like a "Client - Maintable" having a "Family Member - Qualified lookup table". If this is the case, the import is quite easy. First of all you should use an XML Schema as already explained. Then you should use an XML message that describes the full set of the data that might occur (an XML that has a client and at least one familiy member) to create an import map. Uses the "Client" as a source table. In the source hierarchy view you'll see that below the "Client" table the "Family Member" table is linked. If you right-click on this one, you can lookup fields. Then you can use these fields in the mapping.