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.

[Ray0801]

I didn't get you?

[Raghuram_Puram]

@ris.tan it must be the inner join that is failing.

Try using Trim on key columns in extract queries of both DB inputs. Sometimes junk characters may cause the join to fail.

Cheers

[TRF]

@rchinta, fields seems to be numeric.
May be the schema is not aligned with the query for the lookup table

[Ray0801]

I checked with schema,it was rightly aligned but still could not get the answer.

[manodwhb]

@ris.tan , Joining columns are integer data types ,if you are sure about data that should match between two tables then could be point to different data based. could you please check you data base details like schema . to make sure that those two table giving results if you run inner join outside of talend?

[Ray0801]

I actually checked in a microsoft sql server and the inner join worked join

[manodwhb]

@ris.tan , are you pointed to right data based in talend?

[Raghuram_Puram]

As @manodwhb suggested check if you're pointing to the right database.

As a next step, please check if the column order in your select query and column order in component schema are matching or not. That can be the cause sometimes.

Also try selecting single record in both input components and check if the join is working. Ex: emp_na=306 in employee table and salesrepno=306 in customer table. 1 record from main, 1 record from lookup.

Cheers