Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

BroPl
2011-05-23 12:24:57

By iJoin you mean inner Join in t_Map?

mailforvijaym
2011-05-23 11:44:09

Hi,

Ya you need one more input to get employee_id from db you can use tMap or iJoin for mapping the records..

Regards,
Vijay.M

BroPl
2011-05-23 09:35:22

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"?

Board footer

Powered by FluxBB