Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Transformation getting slow

  1. #1

    Default Transformation getting slow

    Hi,

    I'm using a transformation with merge join and when it runs it takes only 3 minutes.But when I'm using the same transformation with dimension lookup/update it is taking more than half an hour.

    Will you please give me a solution for this?

    Thanking you.

    preetha

  2. #2
    DEinspanjer Guest

    Default

    You are comparing apples and oranges there.
    Work with a DBA to make sure that your table has appropriate indices for the queries that the dimension lookup/update step is performing. Also look at your data to determine how many updates the step will be performing and make sure that the DB is tuned appropriately for that.

  3. #3

    Default

    Hi,

    Thank you so much.Now it's working good

    preetha

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.