import Map file failes with single/Multiple Occurance

[Former Member]

Hi All,

Using a file I mapped the source and target structures.. The source file has one multiple occurance node . so I used look up option in source table and mapped with target fields...saved the map..

When I used the following XML file .. I used the same map created befoe... I see the Remote System fields are not failed to map to target structure.. How can I get rid of this issue....

<Product>

--<Name>Rajeev</Name>

--<REMOTE_SYSTEM>

-

---

<Z_MDM_REMOTE_SYSTEM>

-

---

<Z_MDM_SYSTEM_NAME>Panaroma AW Customer ID</Z_MDM_SYSTEM_NAME>

-

---

<Z_MDM_VALUE>600013</Z_MDM_VALUE>

-

---

<Z_MDM_VALUE1>600011</Z_MDM_VALUE1>

-

---

<Z_MDM_VALUE2>600012</Z_MDM_VALUE2>

-

---

</Z_MDM_REMOTE_SYSTEM>

--<REMOTE_SYSTEM>

</Product>

Using above I saved the map.. Its fine.. I am able to import data in to MDM..

When the file has multiple values of remote system as shown below then field are unmapped... vice versa is also the same..

<Product>

--<Name>Rajeev</Name>

--<REMOTE_SYSTEM>

-

---

<Z_MDM_REMOTE_SYSTEM>

-

---

<Z_MDM_SYSTEM_NAME>Panaroma AW Customer ID</Z_MDM_SYSTEM_NAME>

-

---

<Z_MDM_VALUE>600013</Z_MDM_VALUE>

-

---

<Z_MDM_VALUE1>600011</Z_MDM_VALUE1>

-

---

<Z_MDM_VALUE2>600012</Z_MDM_VALUE2>

-

---

</Z_MDM_REMOTE_SYSTEM>

-

---

<Z_MDM_REMOTE_SYSTEM>

-

---

<Z_MDM_SYSTEM_NAME>Panaroma AW Customer ID</Z_MDM_SYSTEM_NAME>

-

---

<Z_MDM_VALUE>600013</Z_MDM_VALUE>

-

---

<Z_MDM_VALUE1>600011</Z_MDM_VALUE1>

-

---

<Z_MDM_VALUE2>600012</Z_MDM_VALUE2>

-

---

</Z_MDM_REMOTE_SYSTEM>

--<REMOTE_SYSTEM>

</Product>

Do I need to create a seperate map for multiple iteration and single occurance..OR missing some thing? Please advice..

Thanks

Rajeev

[Former Member]

Hi Rajeev,

As per your requirement, this structure would not solve your problem. As you said when you have occurrence as 2, then the fields are unmapped. I would suggest you need to change your Structure something like in below manner:

<Product>

--<Name>Rajeev</Name>

--<REMOTE_SYSTEM>

-

---

<Z_MDM_REMOTE_SYSTEM>

<Z_MDM_SYSTEM_NAME>Panaroma AW Customer ID</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>600013, 600014</Z_MDM_VALUE>

<Z_MDM_VALUE1>600011, 600012</Z_MDM_VALUE1>

<Z_MDM_VALUE2>600012, 600013</Z_MDM_VALUE2>

-

---

</Z_MDM_REMOTE_SYSTEM>

--<REMOTE_SYSTEM>

</Product>

If you have correspondingly 3 fields at target side for these 3 src nodes <Z_MDM_VALUE>, </Z_MDM_VALUE1> and

<Z_MDM_VALUE2>. But If you have only1 field at target side for these 3 nodes of SRC then something like in below manner:

<Product>

--<Name>Rajeev</Name>

--<REMOTE_SYSTEM>

-

---

<Z_MDM_REMOTE_SYSTEM>

<Z_MDM_SYSTEM_NAME>Panaroma AW Customer ID</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUES>600011, 600012, 600013, 600014</Z_MDM_VALUES>

-

---

</Z_MDM_REMOTE_SYSTEM>

--<REMOTE_SYSTEM>

</Product>

Since you Source and Target Fields Name should be one and Unique. I mean you should not have more than same node in src structure as in this case you have to map the same two nodes(fields) to single target field which is not possible.

So your SRC node should be one which can have multiple values need to be mapped with Target which is look up multi-valued field in MDM. So I mean you need to identify the source multiple nodes and get it converted in single source multi-valued fields separated by "," OR " : " OR " ;" etc using PI and then bring this structure in Import Manager. So irrespective of fields has single value or multi-valued, you can import data using single map only.

Regards,

Mandeep Saini

[Former Member]

HI,

Its not about remotesystem-value... I have problem wiht all the fields of Remote system..

Suppose:

<Product>

--<Name>Rajeev</Name>

--<EMAIL>

-

---

<Z_MDM_EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>ABC_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>CDE_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

--</EMAIL>

</Product>

I am having problem with EMAIL node.. when ever Email node is repeating I am unable to see any fields of EMAIL are mapped.. If I used EMAIL node with signle values as base file as below:

<Product>

--<Name>Rajeev</Name>

--<EMAIL>

-

---

<Z_MDM_EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>ABC_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

--</EMAIL>

</Product>

THe same I am unable to see the EMAIL fields mapped for a file with EMAIL node is sigle if I use the multiple EMAIL node as base file....

Regards,

Rajeev

[Former Member]

Hi Rajeev

Your understanding is correct. Records can be imported in MDM for a single remote system only in one iteration. Thats why we select the remote system while connecting to the source file itself.

If you want to populate multiple remote system key mappings in MDM we need to have different import maps.

Hope this calrifies-Ravi

[Former Member]

HI Ravi,

May be I took the wrong example..

I am not talking about remote systems... I am talking about XML source file.. If the XML source file consist of single occurance of any qualifier table then those qualifier table fields are not mapping.. IF I used the base file as multiple occurance Qualifier table....

In the same way if I use base file as single occurance of Qualifer table .. Qualifier Fields are not getting mapped if the source file is single occurance..

Suppose :If I use the base file as this and save the map.. I am able to import files whcih are single occurance of EMAIL...

Fields are not getting mapped if the EMAIL occurnace is multiple.....

<Product>

--<Name>Rajeev</Name>

--<EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>ABC_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

--</EMAIL>

</Product>

In the same way: If I use the following XMl as base and create a map and save it.. Able to import files which had email occurance multiple.. Unable to import data and the fields are not mapped ......

<Product>

--<Name>Rajeev</Name>

--<EMAIL>

-

---

<Z_MDM_EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>ABC_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

-

---

<Z_MDM_EMAIL>

<ID>CDE_yahocom</ID>

<TYPE>TEMP</TYPE>

-

---

</Z_MDM_EMAIL>

--</EMAIL>

</Product>

Please advise.. Thanks Rajeev.