Re: Multiple IMPORT in a LOAD - sequencial or parallel?
Hi Akshay, are you talking about MLOAD? I didn't know about that DML limit (and i hope i'll never have to write/maintain a load script where that limit is hit).
For your concerns i'd suggest start reading the MLOAD documentation.
Those IMPORTs are loaded into the Worktable serially. Then the worktable data is merged into the target table using the "Match Tag", thus it's applied in the right sequence.
For your concerns about multiple sessions, these are used for the Aquisition Phase, during the Application Phase each AMPs applies the modifications locally using the Match Tag again. Thus it's still "sequential".