I have to do this a lot. The sql must have a way to match up on all of these. For example, one sql pulls the employee address. The dependent tables do not have an address on them so i have to put the employee's address on the dependent address rows matching on employee_id. I have a pipeline with 21 pipelines in it to get everything on one line. When you do this sort of pipeline, in the mapper, you will see inputs from both documents. For this file, i only want dependent records on my file but i want the input from the EE record to update the dependent's address fields. Those will show on the last mapper. bring in all of the Dependent fields but on the address fields, bring in the EE's address. These will show as Input_1_Address_line_1 for example.
