topic Issue with tELTJDBCOutput component while update in Talend Studio

Issue with tELTJDBCOutput component while update

stautner_a — Wed, 02 Mar 2016 10:44:48 GMT

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

Re: Issue with tELTJDBCOutput component while update

Anonymous — Thu, 03 Mar 2016 05:21:27 GMT

Hi Alexander Stautner,

http://stackoverflow.com/questions/23064099/how-to-load-data-faster-with-talend-and-sql-server

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

Re: Issue with tELTJDBCOutput component while update

stautner_a — Mon, 14 Mar 2016 11:15:47 GMT

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.