Oracle timestamp with time zone into netezza

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
jaya_joseph
Participant
Posts: 13
Joined: Fri Apr 13, 2007 12:23 am

Oracle timestamp with time zone into netezza

Post by jaya_joseph »

Hi,

I have a source table from oracle which have a column with data type timestamp with time zome "15/MAY/14 01:50:02.360645000 PM AUSTRALIA/SYDNEY" .
The task is to read the table (Oracle Connector), perform some transformations (transformer) and load it into Netezza (Netezza connector).
Is datastage able to support/handle this datatype? Or do I need to read/load it as a Varchar?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”