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
Amount Column not loading in Oracle Enterprise Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Re: Amount Column not loading in Oracle Enterprise Stage
So are you sure that 100 records are loaded/updated?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.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 18
- Joined: Mon Mar 26, 2007 1:02 am
Amount Column not loading in Oracle Enterprise Stage
Yes all 100 are loaded but Amount column is loaded with 0.