I want to extract two tables from a db and perform inner join on them using a tMap.

[Ray0801]

Though the data is flowing from DBinput to tMap there is no dataflow between tMap and the output component.

The job shows no error.

I have attached my tMap Editor and Job.

[TRF]

So, no correspondance between emp_id and salesrepno

[Ray0801]

salesrepno is the foriegn key of the customer no

and primary key of employee table known as emp_id

[TRF]

OK but what about the values?
Can you run your job in Trace Debug mode to view the values for these fields during the job execution?

[Ray0801]

[TRF]

Is emp_no an alias for employeeNo?
Else, what's the origin of the emp_no field?
Can you share the select for the employee table?

[Ray0801]

The table i have shared is the select for the employee table

[TRF]

So, what's the origin of the emp_no field?
It doesn't appear into the employee table.

[Ray0801]

Oh sorry i just used the term in place of employeeNo.

[TRF]

So, don't know why you have this result...