tELTPostgresOutput and Update option

One Star

tELTPostgresOutput and Update option

Hi
I am baffled what to write in "WHERE clauses" textbox to make Update happen. Is there a clear sample how to use it exactly - I try to write there sourcetablenamealias.primary_key=targetable.primary_key (like it is in ELTmap) but it wont resolve
I have both source and target defined with the same primary key but ELT component does not seem to use them to update like ETL component does (when I leave "WHERE clauses" textbox empty I get an error that more than one match found for update so I assume i does not actually use it since my primary key is autogenerated unique sequence.
Regards 
Kristjan
Highlighted
Moderator

Re: tELTPostgresOutput and Update option

Hi,
Here is grammar of update sql in postgresql:https://www.postgresql.org/docs/8.1/static/sql-update.html
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.