Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Query Once and use it for entire data load

  1. #1
    Join Date
    Aug 2008

    Default Query Once and use it for entire data load

    Is there a way to query a value from a table once and use the same value in all the rows processed in a transformation ?

  2. #2
    Join Date
    Jul 2007


    If what you need is to add a column with the same value to all rows, you could use a "Join rows (cartesian product)"...

  3. #3


    tdidomenico is right.
    If your one value query target same SQL server you can let your SQL server do this. Simply add a column with the value (via bracketed subselect if necessary).

    21 is only half the truth

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.