Issue with Datetime fields
Posted: Thu Aug 09, 2012 3:04 pm
An issue has been encountered while transferring data from SQLServer to Oracle using DS. The data in DateTime (SQLServer) field is not properly transferred into Date (Oracle) field (minutes are getting corrupted). Date field in Oracle accepts date and time.
To debug, a sequential file and a peek stage were introduced as targets and their values match those of the source column.
Source File Target
2011-12-23 09:14:34 2011-12-23 09:14:34 2011-12-23 09:12:34
2011-12-12 14:52:37 2011-12-12 14:52:37 2011-12-12 14:12:37
2012-02-22 17:13:50 2012-02-22 17:13:50 2012-02-22 17:02:50
2012-01-12 03:32:10 2012-01-12 03:32:10 2012-01-12 03:01:10
2011-11-21 15:40:54 2011-11-21 15:40:54 2011-11-21 15:11:54
2012-07-07 09:36:17 2012-07-07 09:36:17 2012-07-07 09:07:17
2011-11-19 19:08:08 2011-11-19 19:08:08 2011-11-19 19:11:08
2012-07-11 21:47:20 2012-07-11 21:47:20 2012-07-11 21:07:20
2011-09-24 15:13:14 2011-09-24 15:13:14 2011-09-24 15:09:14
2011-12-14 08:26:27 2011-12-14 08:26:27 2011-12-14 08:12:27
Could you please let me know if there are any specific settings to be tweaked to handle this scenario.
Thanks
To debug, a sequential file and a peek stage were introduced as targets and their values match those of the source column.
Source File Target
2011-12-23 09:14:34 2011-12-23 09:14:34 2011-12-23 09:12:34
2011-12-12 14:52:37 2011-12-12 14:52:37 2011-12-12 14:12:37
2012-02-22 17:13:50 2012-02-22 17:13:50 2012-02-22 17:02:50
2012-01-12 03:32:10 2012-01-12 03:32:10 2012-01-12 03:01:10
2011-11-21 15:40:54 2011-11-21 15:40:54 2011-11-21 15:11:54
2012-07-07 09:36:17 2012-07-07 09:36:17 2012-07-07 09:07:17
2011-11-19 19:08:08 2011-11-19 19:08:08 2011-11-19 19:11:08
2012-07-11 21:47:20 2012-07-11 21:47:20 2012-07-11 21:07:20
2011-09-24 15:13:14 2011-09-24 15:13:14 2011-09-24 15:09:14
2011-12-14 08:26:27 2011-12-14 08:26:27 2011-12-14 08:12:27
Could you please let me know if there are any specific settings to be tweaked to handle this scenario.
Thanks