I am trying to import metadata via Oracle Connector import by connecting to Oracle DB . One of the column in Oracle shows the datatype as Date 10 (as it should be ) but once I import the metadata , the same field shows up as timestamp (no length defined )
I was wondering why this would happen and how do I make it a date datatype so that I don t have to append the time and load the table as timestamp.
if the oracle database has it as date then simply change it in the metadata definitions pull down for SQL Type and change to date. You have to make sure to use the data type that the source oracle database says it is.