on 07-04-2018 10:58 AM
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)
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!
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.