Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Selecting and Joining Variables - Full ETL Process Explained

  1. #1

    Default Selecting and Joining Variables - Full ETL Process Explained

    Hi there,

    First of all, feel free to dive into this next image (click to zoom) so the level of awareness of this thread is at the maximum (:



    The goal of this process is to populate a fact table (let's call it FactAnswer) with the following columns : SurveyID, QuestionID, AnswerID, Answer.

    Now:
    • SurveyID, QuestionID, AnswerID are variables set in the system.

    • Answer will be the output of a table input like - " Select ${SGQA} from table_answers"

    What I want, and need, is to make a "FetchAnswers" transformation that selects all $SGQA from table_answers and joins them with the SurveyID, QuestionID, AnswerID previously set.

    So the output , for example, of Select $SGQA from table_answers , $SGQA being 26667X55X851, would be "YES", the fact table should have:

    • SurveyID: 26667

    • QuestionID: 851

    • AnswerID: 1

    • Answer: "YES"

    The granularity of the fact table is one answers, so each line must be represented by 1 SurveyID, 1 QuestionID, 1 AnswerID and 1 answer.

    Any thoughts on this ?

    Thank you all in advance,

    --jr
    Last edited by joaoromao; 02-09-2011 at 01:14 PM.

  2. #2

    Default

    Problem solved

  3. #3
    Join Date
    Nov 2008
    Posts
    143

    Default

    Spread the joy, João!
    What did you do?

  4. #4

    Default

    Quote Originally Posted by renatopb View Post
    Spread the joy, João!
    What did you do?
    It's still a work in process (works with 1 {$SGQA}), but:

    • 1 - Stored the "Copy to Results" output in a aux table.
      2 - Did a table input with selection {$SGQA} (the code).
      3 - Normalized this input
      4 - Joined (cartesian) this normalized input with aux table


    Now I have this problem @ http://forums.pentaho.com/showthread...with-Variables

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.