Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Regarding Oracle to Microsoft sql server migration for Date field

PuneetKumarSep 7 2018 — edited Sep 11 2018

Hi All,

My source system Oracle has a Date field and in ODI the default Microsoft SQL Server architecture settings consist of DATETIME as Default date datatype mask.

Can anyone suggest me as how to change it to Date or Datetime2, I have tried it by changing, but when i generate any scenario with having Date or Datetime2 field, it failed in generating that, says not supported field.

As, Datetime will only have range from 01-01-1753 to 31-12-9999, and we have some 1203, 0008 years in my source system.

Please suggest, how to handle this or change the default datatype.

Thanks

Puneet

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2018

Added on Sep 7 2018

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

136 views