Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Add Column to Dimension with Hashcode

  1. #1

    Default Add Column to Dimension with Hashcode

    I have a dimension table that is using a calculated hashcode column as the key for lookups. I would like to add a new column to this table that should also be included in the hashcode calculation. How can I add this column and update the hashcode value for the current rows in the table?

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

    Default

    Hash codes are only supported for the "Combination lookup/update" step, not the "Dimension lookup/update".
    IMHO, it's only needed in very extreme situations with a host of natural keys.

    ... or maybe I'm just misunderstanding the problem :-)

    Matt

  3. #3

    Default

    The reason I'm using the hashcode is because there is no natural key and the columns are all string columns. Regardless, what do I need to do to regenerate the hash value after I add the new column?

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

    Default

    In that case you need the "Combination lookup/update" step mentioned above. That will take care of updating the desired junk dimension for you...
    and it automatically calculates the hashcodes for you.

    Matt

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.