Deleting or updating data with dboutput

CloverDX Platform
1

Hi !

I want to transfer data from a table (table A) to another table (table B : same metadata) on other Oracle instance.

I use DATAINTERSECTION component to :
- only insert new rows from table A to table B
- updating rows of table B which haved changed
- deleting rows of table B which have been deleted in table A.

How can I delete or update rows with cloverETL and with DBOUTPUT component ?

Thanks a lot.

2

Hello !

DBOutputTable can taky any SQL/DML command - including delete.

Use “sqlQuery” or “sqlCode” to provide something like this:
“delete where <key_field>=?”

And use “cloverFiedls” to select which field (its value) from Clover should be used in place of the “?”.

See this simple example:
--------------------------------



--------------------------------

3

do the fields passed to the cloverfields need to be in the order of the ?'s or does it matter?

4

you can use fieldMap attribute to specify the exact mapping between clover and db fields