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.
Thank you
