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...
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.