Nullable Value transforms to 0 while writing to OracleDB
Posted: Thu Nov 29, 2018 1:24 am
There is a job
ALotOfTransformation -> finale_Transfomer -> Oracle DB
In the final_Transformer there is a Field defined as Decimal 25,2 nullable. The row with the problem has the value NULL. When I write the field to the database, the NULL value suddenly becomes 0.
The field in the Database is configured as NUMBER(25,2) nullable.
I tested it with the following Job setup:
ALotOfTransformation -> finale_Transfomer -> PEEK
... and the Peek shows me the NULL Value.
Any Ideas why the Oracle Stage Changes NULL to 0 ?!
ALotOfTransformation -> finale_Transfomer -> Oracle DB
In the final_Transformer there is a Field defined as Decimal 25,2 nullable. The row with the problem has the value NULL. When I write the field to the database, the NULL value suddenly becomes 0.
The field in the Database is configured as NUMBER(25,2) nullable.
I tested it with the following Job setup:
ALotOfTransformation -> finale_Transfomer -> PEEK
... and the Peek shows me the NULL Value.
Any Ideas why the Oracle Stage Changes NULL to 0 ?!