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