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
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.