Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: join tables in kettle

  1. #1
    Join Date
    Mar 2011
    Posts
    4

    Default join tables in kettle

    Hi,

    I have a question. I have an OLTP database and making a DW. In my DW design one dimension table will hold values from say 6 OLTP tables. Now joining those 6 tables should be done in OLTP or in Kettle? If use OLTP which in my case in MySQL database so I have to make a table to put the join output there and then use kettle to transfer the data from that table of MySQL using Input table?

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    Use a single Table Input step. You don't have to create a staging table for this. Just create the proper SELECT joining the data from the 6 source tables.

  3. #3
    Join Date
    Mar 2011
    Posts
    4

    Default

    Quote Originally Posted by Maria Roldan View Post
    Use a single Table Input step. You don't have to create a staging table for this. Just create the proper SELECT joining the data from the 6 source tables.
    Thank you.
    Just to clarify I will bring only one Input Table and will write the Join query in it which will do the joining and the rest will be done in cattle?

  4. #4
    Join Date
    Sep 2007
    Posts
    834

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

    Default

    Mooooh indeed mooooh

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.