In Talend Open Studio, the tMap will have as main input the "sales" and as lookup input, the "articles" list. By default, the join is an "outer join". If you want to simulate an "inner join" you have to add a "condition constraint" in the output. In the example I take in this post, the condition would be to check if the name of the article is defined:defined $rowN[article_name]
DBD::mysql::st execute failed: Column set to default value; NULL supplied to NOT NULL column 'RES_IDENT' at row 1 at C:\progetto_ETL_Khalix\TOS-Win32-20061004-1934-V1\TOS-Win32-20061004-1934-V1\workspace\.Perl\PROVA.process_testjob.pl line 1481.
can't execute insert query
Job testjob ended at 09:12 20/11/2006. [exit code=2]
Run Process wrote:
DBD::mysql::st execute failed: Column set to default value; NULL supplied to NOT NULL column 'RES_IDENT' [...]
Maybe it would be better if you put a further configuration parameter in the tMap, allowing to choose whether to make inner join or outer join. The writing of perl code whould be reduced to the minimum, since not everybody is an expert Perl programmer...And the philosophy of graphical ETL tools like Talend should be to avoid people, as much as possible, knowing SQL or scripting languages in order to create ETL processes...
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend