Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Need help on One-To-One Mapping

  1. #1
    Join Date
    Apr 2006
    Posts
    13

    Default Need help on One-To-One Mapping

    Hi,


    We are very new to Kettle,we created a job and we have one source and one target table. the column names and datatypes are vary from source to target, we are trying to do one-to-one mapping.Which transformation should we use?



    Thanks for reply
    &
    Thanks to All
    Srinu

  2. #2
    Join Date
    Apr 2006
    Posts
    9

    Default RE: Need help on One-To-One Mapping

    Transform->Select Values


    This step allows to select which precedent columns you want to copy to your target table, also you can rename columns and change their types (using metadata tab)



    your transfortion should look like



    SOURCE TABLE --> SELECT VALUES--->TARGET TABLE

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.