Amount Column not loading in Oracle Enterprise Stage

karthik_j013 · Post by **karthik_j013** » Tue Feb 21, 2012 1:01 am

Hi All,

We have a Job, which is loading from a flat file to Oracle table, which is one to one loading on all the column with some trim functions used.

Here in the table we have column A datatype Decimal (38,5) in which amount have to be loaded.

When I try to load, only few records with amount is loaded; say like 100 records (all 100 records contains amount from the source file) only few records amount is loaded like 30 records and the rest is loaded with 0.

I am not getting neither a warning.

But the same is working fine in a different envirnoment, I am facing this problem dev but in UAT envirnoment it is fine.

Tried to check the envirnoment variables in both, the envirnoment varibles and setting are same in both.
NLS setting is same in both envirnoment.

Tried checking with DBA on Oracle envirnoment UAT and DEV are in sync.

Please let me know where could be the problem in envirnoment settings.

Thanks,
Karthik

kandyshandy · Post by **kandyshandy** » Tue Feb 21, 2012 1:30 am

karthik_j013 wrote:all 100 records contains amount from the source file) only few records amount is loaded like 30 records and the rest is loaded with 0.

So are you sure that 100 records are loaded/updated?

karthik_j013 · Post by **karthik_j013** » Tue Feb 21, 2012 5:17 am

Yes all 100 are loaded but Amount column is loaded with 0.

chulett · Post by **chulett** » Tue Feb 21, 2012 7:45 am

Show us the 'trim functions' you are using. That and examples of values that load correctly and ones that ended up zero.

DSXchange