3251962 - Operator Table Producer generate only CLOB Objects instead of VARCHAR

When writing a table to SAP HANA using Generation 2 operators, string columns are saved as NCLOB instead of the expected VARCHAR data type.

The graph will get error like:

Data type mismatch: In query <LoadMapper_******_tableproducer1>, an expression of type <LONG> is mapped to column <***> of type <VARCHAR>. Specify an expression of compatible type or change the type of the output column. | error with process "": Process(es) terminated with error(s). restartOnFailure==false

SAP Data Intelligence (all versions)

nclob, clob, str, di , KBA , CA-DI , Data Intelligence , Problem