Hi,
I have a parallel job that is reading data from SQL server table and loading into a oracle table. There are 7 to 8 date columns in both source and target tables.
Transformer is just a plain one to one mapping.
The problem is whenever I run this job in production environment, one or the other date columns is populated as null values, even though the source SQL table has data for all the date columns.
This job completes successfully without throwing any warnings and when I verify data by querying database I see nulls.
When I run this job from development env it works fine and all date columns show data.
Can somebody help me solve this issue?
Thanks,
Srilaxmi.
Date columns in parallel job behaving peculiarly
Moderators: chulett, rschirm, roy
Re: Date columns in parallel job behaving peculiarly
What are some of the values being dropped? Is the complete record being dropped or just the column value? Does your job work properly on your Development environment if the same values are in the source table?srilaxmi wrote:The problem is whenever I run this job in production environment, one or the other date columns is populated as null values, even though the source SQL table has data for all the date columns.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Any one or every one? Randomly/intermittently, for every row, or for something for which you can discern a pattern? Are your dates using the default date format?
That's just a few of the things that a systematic diagnosis might investigate.
That's just a few of the things that a systematic diagnosis might investigate.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI