This screenshot shows the completed mapping from the master detail flat file into two target tables. To the left, ordered from top to bottom, are the Sequence operator SEQ1 and the Flat File operator EMPLOYEE_TXT. To the right are two Table operators, ordered from top to bottom, PAY_DETAILS and EMPLOYEE_MASTER.
Arrows join columns in EMPLOYEE_TXT to the PAY_DETAILS and EMPLOYEE_MASTER tables. Arrows connect the NEXTVAL column in SEQ1 to EMPLOYEE_MASTER and the CURRVAL column in SEQ1 to PAY_DETAILS.