Hi, I need to delete rows from an Oracle table based on the column values, for example registration_year < 2020 and status not=sold. Could you please let me know which component to use.
You can use tOracleOutput component and select the table action 'Delete' to delete the rows, before tOracleOutput, use tFilterRow to filter the rows that matches the condition you set.
