Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How does Table Ouput Work

  1. #1
    Join Date
    Aug 2007
    Posts
    15

    Default How does Table Ouput Work

    Hi,

    How does the Table Output step match which column in a transformation stream maps to the columns in the target table? Does it use the column name? Or does it use the column position?

    Thanks,

    -Dipin

  2. #2

    Default

    It matches by name. You could easily have tried this out yourself.

  3. #3
    Join Date
    Aug 2007
    Posts
    15

    Default

    Thanks for the information.

    I normally would have tried it out myself but I didn't have the time then so I decided to fire off a quick post.

    Next time I'll wait until I have more time and try things out for myself.

    Thanks,

    -Dipin

  4. #4
    Join Date
    May 2010
    Posts
    21

    Default How does Table Ouput Work - Name Matching or Position Matching

    I am trying to insert records in an oracle-table with table-output-step.
    The state that the output is done by the attribut name is not right.
    Sometimes you have to rename the attributes in a select-step before the output-step.
    And rename means that you have to name them as in the target-table.
    So this is a lot of effort when you have 30+ attibutes in the target.

  5. #5

    Default

    Quote Originally Posted by dipin View Post
    Hi,

    How does the Table Output step match which column in a transformation stream maps to the columns in the target table? Does it use the column name? Or does it use the column position?

    Thanks,

    -Dipin
    Name based... Simple "as" in your initial select or select Database Fields in the Table Output and map them properly

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.