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 ?!
Nullable Value transforms to 0 while writing to OracleDB
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Wed Apr 29, 2015 12:48 am