Hi, in tMap it is not possible to lookup additional information with a dynamic sql query. My tSybaseInput_1 is only fired at startup of my job, but i want to query the database for each row. In tJavaRow_1 i also set the contextvar "currentAZ", which is used by tSybaseInput_1 Do you have a suitable solution, i don't want to fetch the whole table in tSybaseInput_1.
Query in t_SybaseInput_1: "SELECT AZ FROM FCAdmin.Akte WHERE AZ = '"+context.currentAZ+"'"
Hi, Can someone tell me how to perform dynamic look up in Talend? please see below an example problem that requires dynamic lookup. example: source file has the following data employee_name|employee_Id =========================== Ted | 100 Mary | 200 Ted 100 target table structure: surrogate_Id | Employee_Name | Employee_Id =========================================
after load the target table should look as shown below surrogate_Id | Employee_Name | Employee_Id ======================================= 1 | Ted | 100 2 | Mary | 200
currently when I do a look up and insert data, employee Ted is getting inserted twice. This might be because the commit happens at the end of the job. How can I include records that were inserted as part of the current transaction but not commited?? Thanks in advance