I'm currently facing a problem with the tELTMap component of Talend. I'm using ELT JDBC components for Oracle databases.
I've created tables in my Oracle database with quotes and i want Talend to match case. So, I've added \" at the beginning and the end of the dbColumn in the schemas. However, if I chain two tELTMap, the query created by the second one contains compilation errors. The main problem is that double quotes aren't escaped a second time.
I've created a simple example to show you the problem. I've added two tELTJDBCInput for clients and their amout stats.
Then, i linked clients with a tELTMap component and did a 1 for 1 mapping.
I've linked another tELTMap with the previous one and sales statistics.
Then i linked the last one with a tELTJDBCOutput.
When i looked in the code generated, i can see and error in the query generated.
Any solution ?
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