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
    Posts
    15

    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
    Posts
    1,013

    Default

    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

    Default

    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).

    Regards,
    Christoph
    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.