top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

In a mapping if three are 2 targets to load header and detail, how to ensure that header loads first then detail table.

+1 vote
362 views
In a mapping if three are 2 targets to load header and detail, how to ensure that header loads first then detail table.
posted Feb 22, 2016 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Constraint Based Loading (if no relationship at oracle level) OR Target Load Plan (if only 1 source qualifier for other tables) OR select first the header target table and then the detail table while dragging them in mapping.[social locker]

answer Feb 24, 2016 by Manikandan J
Similar Questions
0 votes

Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?

0 votes

Source
Id,name
1,Andrew
2,john
3,Robert

Target
detail
((1/Andrew)(2/john)(3/Robert))

please provide solution for the above scenario. Thanks in advance.

...