Skip to Content
0
Former Member
Jul 26, 2010 at 06:19 PM

import Map file failes with single/Multiple Occurance

31 Views

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