...
We made a change for the EDS query generation in terms of NUMBER data base field. Additional logic was added for such fields, in order to make some formatting on the query step instead of validate and convert each number on transformation step. The only noticeable change is that decimal numbers where float piece is equal 0, will look in output like this:
255 instead on 255.0
0 instead of 0.0for all other numbers there should be no changes.
How query looks before and after changes on REC_COUPON field: Before: MASTERTABLE.REC_COUPON REC_COUPON,
*After: * CASE WHEN MASTERTABLE.REC_COUPON IS NULL THEN NULL WHEN MASTERTABLE.REC_COUPON = 0 THEN '0' WHEN MASTERTABLE.REC_COUPON < 1 AND MASTERTABLE.REC_COUPON > -1 THEN TO_CHAR(MASTERTABLE.REC_COUPON, 'FM0.099999999999') ELSE TO_CHAR(MASTERTABLE.REC_COUPON) END REC_COUPON,
...