Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: how to populate dimension table from OLTP

  1. #1
    Join Date
    Mar 2011
    Posts
    4

    Default how to populate dimension table from OLTP

    Hi,
    I just started with this amazing tool kettle with the intention of making 2/3 dimension table. I have a database in mysql with 30 tables. Now my intension is to join 4/5 tables and with their data populate the dimension tables.
    Allthe documents saying about taking input from text/csv files but mine is a database and then I have to join couple of them and out of that have to make dim table in one go. Which options from the left should I choose for this?
    thanks.

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

    Default

    For Kettle it doesn't matter where the data comes from. Just feed it into the "Dimension Lookup/Update" step and you'll get a hybrid slowly changing dimension.

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.