DSXchange

Hello All

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.

Please advice

Thanks

All DATE data types in Oracle have a time component.

And DATE data types store the data in Oracle's internal foramts.

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.