Source and Target have DRS stages data is not loading.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Tue Jun 20, 2006 10:22 pm
Source and Target have DRS stages data is not loading.
Hi,
My Source is DRS stage and Target also same.But data is not peoperly loaded into target.
My source having Date filed and its having data also.After the run the job the data in Date field is not loading into target.Its showing the empty values.How to solve this one.Please help on this.
Regards,
Reddy.
My Source is DRS stage and Target also same.But data is not peoperly loaded into target.
My source having Date filed and its having data also.After the run the job the data in Date field is not loading into target.Its showing the empty values.How to solve this one.Please help on this.
Regards,
Reddy.
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Hi Reddy
Whether You are getting any errors? If not run the job with Array Size 1 and i hope you may get some errors.
Still the data is not loaded, then I hope you are having NULL in your data and you are trying to populate that to a Not Nullable Column.
Do the Null Handling, Your problem will be solved.
Whether You are getting any errors? If not run the job with Array Size 1 and i hope you may get some errors.
Still the data is not loaded, then I hope you are having NULL in your data and you are trying to populate that to a Not Nullable Column.
Do the Null Handling, Your problem will be solved.
-
- Participant
- Posts: 30
- Joined: Tue Jun 20, 2006 10:22 pm
What are the source and target databases (DB2?). If DB2, try changing all columns with metadata DATE to TIMESTAMP and see if that fixes your problem.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
The best way to Debug this will be put sequential file just after the source DRS and just Before the Target DRS and Pull out the date field in the files. You will know where the problem lies - whether in reading or while writing.
After you do that you will need to change the format so that it becomes compatible with your source and target DB.
After you do that you will need to change the format so that it becomes compatible with your source and target DB.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Tue Jun 20, 2006 10:22 pm
How is it possible that the input is a valid, non-null date field and is not showing up in the sequential file. You must be constraining it in your transformer stage.
Another wierd thing, how come its showing up in the database and not in the sequential file
Another wierd thing, how come its showing up in the database and not in the sequential file
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Tue Jun 20, 2006 10:22 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The issue is that the DB2 Plugin and DRS stage set to DB2 have the same stupid logic that translates DATE datatype values to the internal DS BASIC date integer value. Toggling to TIMESTAMP prevents this from happening, and everything works fine. When loading into a table, DATE columns are expected to have the internal DS BASIC date integer values, toggling to TIMESTAMP bypasses that logic as well.
Yes, you can use VARCHAR as well, just don't have the data type set to DATE. Sorry, take it up with Ascential.
The other alternative is to ALWAYS use an ICONV/OCONV date formatting derivation immediately before/after a DB2 or DRSw/DB2 stage. Toggling the metadata is easiest.
Yes, you can use VARCHAR as well, just don't have the data type set to DATE. Sorry, take it up with Ascential.
The other alternative is to ALWAYS use an ICONV/OCONV date formatting derivation immediately before/after a DB2 or DRSw/DB2 stage. Toggling the metadata is easiest.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
By the way, the Informix, Sybase, and DB2 plugins all have this same issue. Get used to toggling DATE to TIMESTAMP. the DRS stage is just a facade to the plugins, so it's all the same.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle