Hi, I'm trying to perform an insert\update on redshift tables. I want to insert new rows and update the rows already present. I need to use ELT components and I don't see anything specific for Redshift, so I'm using generic tELTJDBC components I thougth I should join twice the source rows with the target table: - table SRC left join table TRG on SRC.key_col = TRG.key_col where TRG.key_col is null --> the rows has to be inserted - table SRC inner join table TRG on SRC.key_col = TRG.key_col --> the rows has to be updated But I'm not sure how to use tELTJDBCOutput and how to set the update condition.
