Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dimension lookup/update

  1. #1
    Join Date
    Feb 2011
    Posts
    8

    Default Dimension lookup/update

    Hello,

    When i use the Dimension lookup/update stage, the insert and update's are slow. The database is Mysql. Is it normal or what can i do to increase the performance? What is the default Ram that Kettle use? Can i increase this? Kettle runs on Mac OSX.

    Thanks

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

    Default

    You normally put an index on the natural key(s) of your 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.