Hi All,
I am begineer to Talend and struggling with data transformation.I have created two Oracle connections one being source db i.e. MX52REF and other being target i.e. MAXSTG.I am selecting records from source db and applying a fliter preceded by tMap for transformation.This transformed data is pushed in to table as LOCATIONS75.After which I am commiting and closing the connection.I have attached screenshot of my job as below.
when I run this job, it stops after sometimes with throwing error as :
connecting to socket on port 4055
connected
connecting to socket on port 4493
connected
ORA-01722: invalid number
disconnected
disconnected
However I can see all 30 rows are transformed and all components are ok.Still there are no records inserted in LOCATIONS75 table.
My question is : is there any way can we find which record has caused 'invalid number' error?