Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Newbie Question ... sorry :-)

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Newbie Question ... sorry :-)

    Matt,


    I would like to know if it is possible to make simple transformations that reference var's in the correct syntax: ex ${global_key}$ in the SQL for a Table Input step without using a "Get System Info" step before it. I would then expect Chef to have a step within the main job that sets the ${global_key}$ and since it is being set "globaly" then all the transformations that reference ${global_key}$ are getting the cascaded value for this ETL run's version of ${global_key}$.



    In other words the transformation is only a "Table Input" step and a "Table Output" step.



    If this already is possible ... please excuse me :-)



    I have searched and can't seem to find an example of this being done.



    If it's not possible can you suggest a way of doing this or must every transformation include a "Get System Info" step to get a solution for my example.



    I know you have said you are working on new variable functionality ... just wondering if it will include global vars.



    Thanks in advance!



    Kick ass tool :-)

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Newbie Question ... sorry :-)

    This is almost possible in the latest version. The only piece of the puzzle that's missing is a "Get Variables" step.
    But it seems that this one is coming soon.


    However, I don't think it's a good idea to do variable replacement inside of SQL scripts.



    The link you wanted



    Matt

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Newbie Question ... sorry :-)

    Thanks Matt!


    :-)



    If I need to drop the value that is held in ${global_key}$ into the table for each load how would you suggest merging it into the stream?



    Again thanks!

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Newbie Question ... sorry :-)

    Well obviously, I suggest to wait for the "Get Variables" step.
    Should arrive any day now.

    M.

  5. #5
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Newbie Question ... sorry :-)

    Perfect Thanks ...

    Do you ever watch Seinfeld ?

    If so, have you ever seen the Soup Nazi episode ?

    No offense .. and I laugh my ass off at the way you zing some of the people posting ... really I do!

    I love it ! Don't change!

    :-)

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Newbie Question ... sorry :-)

    Big fan it's a shame I can't watch it more often.
    No I don't remember: no soup for you. :-)

    If I come across a bit bluntly at times, please remember I'm dealing with +120 mails/day at times. My appologies!

    Only 40 mails today:a bit slow ;-)

    Matt

  7. #7
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Newbie Question ... sorry :-)

    I Love Ordering Soup!

    I'll say it again ... "Don't Change!"

    I understand the workload and think you and the team are really getting in the "Big Boy's" faces!

    It must be somewhat amusing to know you are a threat!

    :-)

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.