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:
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.