Database Writer - Compress Basic

Hi,

 

I would like to know if it is possible to run user defined sql when using the database writer node. I have a large table that I am trying to write and our IT department would like the table compressed using the Oracle "Compress Basic" statement.

 

Does anyone know how this may be able to be done?

 

Cheers

Hi,

you could use the Databsae SQL Executor node to create the table with compression prior writing data into it using the Database Writer node. Please make sure to have the "...to existing table" option selected in the Database Writer node.

Bye,

Tobias