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