zeros being padded (prefixed) to a decimal field
Posted: Mon Apr 05, 2010 7:10 pm
-Pulled in metadata using orchestrate method in table def
-intiger came in as decimal(38,10)
-when data flows through these fields, its padding zeros(0) in the front.
example: oracle db has intiger 101
DS is reading as "000000000000000101" (lots of zeros)
Any reason this is happening?
Any way to fix this, any APT_ variable to change ? or something to do with fixed width field?(how to declare this or handle this)
This is creating issues with lookup, as its comparing this value to 101 and also writes these zeros to a flat file.
This is happening for all the number fields, so its not good to apply trim or removing leading zeros with functions.
APT_STRING_PADCHAR is 0x0, in the project -- any relavence?
-intiger came in as decimal(38,10)
-when data flows through these fields, its padding zeros(0) in the front.
example: oracle db has intiger 101
DS is reading as "000000000000000101" (lots of zeros)
Any reason this is happening?
Any way to fix this, any APT_ variable to change ? or something to do with fixed width field?(how to declare this or handle this)
This is creating issues with lookup, as its comparing this value to 101 and also writes these zeros to a flat file.
This is happening for all the number fields, so its not good to apply trim or removing leading zeros with functions.
APT_STRING_PADCHAR is 0x0, in the project -- any relavence?