This screenshot shows the completed mapping from master-detail flat file with a direct path load. To the left are a Constant operator CONSTANT, a Data Generator operator DATA_GENERATOR, and a Flat File operator EMPLOYEE_TXT. On the right are two Tables operators, PAY and EMPLOYEE.
An arrow connects CONSTANT to DEPTKEY attribute of PAY. Arrows connect the RECNUM attribute of DATA_GENERATOR to the RECORDNUMBER attribute of PAY and the RECORDNUMBER attribute of EMPLOYEE. The attributes in the group PAYROLLDETAIL of EMPLOYEE_TXT are connected to PAY using arrows. The attributes in the EMPLOYEEMASTER group of EMPLOYEE_TXT are connected to EMPLOYEE using arrows.