Maintain One-to-Many relationship

[former_member210091]

Hey Guys,

I need to design a Repository in which i have to maintain one-to-many relationship. A Customer can have multiple Countries associated with it. i will get an XML file from PI and i need to import this (via Import Manager or MDIS) into MDM.

the XML file will look something like below :

<?xml version="1.0" encoding="UTF-8" ?> 
- <ProductsMsg>
- <Products>
  <CompanyName>XYZ</CompanyName> 
- <Country>
      <Name>US</Name> 
  </Country>
- <Country>
      <Name>IN</Name> 
  </Country>
- <Country>
      <Name>UK</Name> 
  </Country>
  </Products>
  </ProductsMsg>

As you can see above,"CompanyName" occurs only once but "Country" is occuring multiple times within the XML."CompanyName" is a text field but "Country" field must come from a lookup table.Now how will i design the repository for this?

I know i can define "CompanyName" as xsd:string in repository but how will i define "Country" field? what kind of lookup will it be ?

Also i would need to syndicate this file later on (to other systems) in the same format (one "CompanyName" but multiple "Country" tags with it) so the design of repository should be able to handle this syndication requirement as well.

Thanks

Saif

[former_member210091]

Oops sorry, duplicate Post