Skip to Content
0
Jul 04, 2018 at 09:58 AM

Mapping of nested tables with more than one hierarchy level

174 Views Last edit Jul 04, 2018 at 01:46 PM 2 rev

Hello.

I have the requirement to map a set of nested tables to a flat table structure.
In additon the foreign keys of each Level have to be mapped to each target table.

The Basic structure looks as follows:

Source:
HEADER (structure)
--HeaderID
--Field1
--Field2
--ITEM (table)
----ItemID
----Field3
----Field4
----DETAILS (table)
------DetailsID
------Field5
------Field6

Target:
INBOUND_CONTAINER
HEADER(table)
--HeaderID
--Field1
--Field2
ITEM(table)
--HeaderID
--ItemID
--Field3
--Field4
DETAILS(table)

--HeaderID
--ItemID
--DetailsID
--Field5
--Field6

I have already managed to fill HEADER and ITEM in the target (somehow).
But when trying to map DETAILS, nothing in the target DETAILS table is filled.-

Is it possible to map such kind of source structure in general?

I am thankful for all kinds of advice.

Thanks!