Oracle date-type column import & decimal conversion

[arun_im4u]

Hi,

When i try to import column definitions from an oracle table using Orchestrate schema definitions it converts all the date type fields into timestamps.

I have to load these columns into a numeric column in the target table.

Question 1: How can I import date type column as date?? Does DS support that?

Question 2: If it got imported as timestamp how can I convert that into decimal? I tried the Timestamptostring(stringtodecimal). But not able to make it work. Timestamp column format= 7/31/2004 Target column: 20040731.

Thanks.

[ray.wurlod]

DataStage but Oracle doesn't. When DataStage asks Oracle what the SQL data type is, Oracle reports "timestamp". A DATE column in Oracle is actually a date and time column, as you may be aware.

To convert the date part you therefore first need to extract the date part from the timestamp.