Skip to Content
0
Former Member
May 13, 2010 at 09:49 AM

Import failed with multivalued tuple fields 7.1 sp4

41 Views

Hi All,

We have a issue while loading the data in to Main table and Multivalued tuples.

we want to import two fields from main table along with 3 fields from multivalued tuple for a record.

Ex: Main table fields ( ID, Name) and Tuple values( ID, Name1, Name2 and Name Type) this is multivalued.

01, test, 001, tuple test1, tuple test2, xxx

tuple test3, tuple test4, abc

now we have 3 scenarios to

1. In tuple vaues, If an empty tag comes whats the behaviour

2. If the tag doesnot exist in xml whats the beaviour

3. If there were 3 values.. in the intial load, and now only 2 values are coming in that case it has to delete the 3rd value.... how to achieve this functionality.

thanks in advance

Anil