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!
Learn how and why companies are moving to the Cloud
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.