Hi, I have an issue with the tELTJDBCOutput. I have a stage and a destination table and try to fill data from the stage table to the data. I follow approach with splitting the data in insert data and update data as described here http:// stackoverflow. com/questions/23064099/how-to-load-data-faster-with-talend-and-sql-server The insert part works without any problems, but the update part doesn't work because i get an "single-row subquery returns more than one row" error. So the question is how do i tell the tELTJDBCOutput component to update it correctly line by line? I think i have to do something with the where clause of the tELTJDBCOutput, but i don't find any example in the documentation or internet how to use it and any try of writing something like stagekey = destkey results in different errors. Before you ask, using a tJDBCInput and a tJDBCOutput for the updates solves the problem and works, but because i have to do this with a few million lines it takes too much time so i am looking for a solution with the ELT components. Thank you for your help, Alexander Stautner
The three ELT JDBC components are closely related, in terms of their operating conditions.(tELTJDBCInput, tELTJDBCMap, tELTJDBCOutput) What's your current job design? Note: ELT DB components are working within one DB. For example, you have to load your stage table to the destination table which are in the same DB .
xdshi wrote:
The three ELT JDBC components are closely related, in terms of their operating conditions.(tELTJDBCInput, tELTJDBCMap, tELTJDBCOutput)
What's your current job design?
Note: ELT DB components are working within one DB. For example, you have to load your stage table to the destination table which are in the same DB .
Best regards
Sabrina
Hi Sabrina, the job design is exactly as in the link. I want to know how the setup of the UpdateOnDest tELTJDBCOutput should look like. Because every combination I tried results in an error and the talend documentation contains only insert cases.
Thank you for helping.
