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

Question

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?

Answer 1

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]