Amount Column not loading in Oracle Enterprise Stage
Posted: 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
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