NULL value is passed in column after it transformed in tmap

[Anonymous]

Hi All,

I have two table in MS SQL

1st Table (Product-Source) - Having columns Product(String) 

2nd Table (EPAIS - Source) - Having columns Product(String) and EPAIS(numeric(10,2))

Need to inner join product and EPAIS table with Product and have to insert EPAIS to Target table. When i tried to insert it using tmap, the column of EPAIS(in target table) is inserted with value NULL even there exist values in source EPAIS column.

In talend the datatype of EPAIS is changed to BigDecimal(10,2). I tried with changing the datatype to int, float and double. It remains the same. PFA

And Please assist me in solving the issue

[TRF]

Set "Catch lookup inner join reject" to false.

It should be set to true only to catch Product rows with no corresponding EPAIS row (rejected from inner join).

[Anonymous]

Thank you for your update @TRF 

Yea I have updated catch lookup inner join reject to False as well, but its not inserting even single records in the table.

[TRF]

What if you run your job in debug mode to see the out vallues from your tMap? Is there any records on this flow?

[Anonymous]

@TRF it shows zero record. PFA

Debug.jpg
TMap.JPG

[TRF]

So the problem may be with your data (main or lookup table) or you don't choose the expected field to construct the join in the tMap or the option "Catch lookup inner join reject" is still set to True