Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: SCD type 1 and type 2 for the same dimension

  1. #1
    Join Date
    Jun 2009

    Default SCD type 1 and type 2 for the same dimension

    I've got a dimension table that needs to be updated directly (type1) if one of the columns changes, but need to have a new insert record (type2) if another column changes. I tried to work it out with the Dimension lookup/ update step but I couldn't get it to work. Neither with Insert/ Update step. Can anybody point me to the right direction? I definitely need the dimension lookup/ update step for all those extra columns and time management that it performs. I was wondering if I need to use another step with it.
    Last edited by rkim; 06-25-2009 at 12:54 PM.

  2. #2
    Join Date
    Apr 2008


    Use the Dimension Lookup / Update step.

    Default for Lookup / Update fields based on the key is "Insert", but you can change that to "Update" or "Punch Through"

    I know that one of those options will do what you want, just not sure which.

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.