I have a trouble in a tMap when i am trying to map with a left join and compare after the value of the key to update or insert.
the problem is the key is a number, and Talend cast it in int rather than Integer so it's value can't be null.
How can i cast it in Integer knowing that's it's just the output of DBinputcomponent, i don t see any options.
if=null works with integer and not with int.
But if i want an integer i have to cross the nullable case which is kind of problematic as a primary key value, and it will change my value in-built
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema