The Definitive Guide to Data Quality
Solved! Go to Solution.
I have mapped two tables connected to each other with fk. The situation looks like this:
Employee_id of table employees has been generated from sequence on insert
Employee_id in salary table has to be filled in from Employees table joined on personal insurance number mapped from csv input.
Both mappings are done in one job Employees have insert order 1 and salary has order 2 how can I map the employees_id ? Do I need to add anothe PostgreSQL_input or can it be done inside tMap by usin "SELECT employee_id from employees emp where emp.insur_no = row1.columnName"?