tELTOracleOutput - update same table

[Anonymous]

Hello,

I wanted to run the following query on the same target table as input table.

How to achieve?

UPDATE TABLE1

SET COL1 = NULL,

COL2=NULL,

COL3='ABCV'

As this table contains 4 million rows how to run the below query in ELT.

I tried linking input table(TABLE1) to tELTMapOracle where I have hardcoded the required value.

This I have linked to tELTOracleOutput.

Both the input and output schema has only the required columns.

This does not seem to work.

Thanks

[fdenis]

if there is no key or values in your query you did not nead tetl. You just have to run your query.