Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Table Output step - Data type

  1. #1

    Default Table Output step - Data type

    Hi,

    I am using a DB2 Database. It has 'Date' and 'Timestamp' datatypes.

    I have a column 'A' of 'date' type (yyyy/mm/dd) in my transformation.

    When i ran the transformation, the data was not getting loaded because of Datatype error.

    When i checked the SQL in Table Output, it shows an 'alter' table sql to change the datatype of 'A' from 'Date' to 'Timestamp'.

    Cant we load 'Date' type columns in PDI?

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi Pon.
    Maybe you need to use a Select Value step to convert your Date yyyy/mm/dd into a different Date format which is compatible with the output database.

    Mick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.