Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Help on Database Lookup/Update (SCD Type 2)

  1. #1

    Default Help on Database Lookup/Update (SCD Type 2)

    Version - 4.1.1 GA Spoon - windows

    We are using Dimension Lookup/Update step (SCD Type 2). In the Fields tab we have 3 fields listed say field A, B and C and all have "type of dimension update" as "Insert". Everything is ok till now. However we have 4th field say field D. Now consider the below cases:
    1> One of the fields from A,B or C changes and D does or does not change - We want a new record to be inserted with all the values A,B,C,D
    2> None of the fields from A,B,C change but D changes - We don't want to insert a new record and also don't want to update any existing one.

    How can we achieve this?

    thanks in advace for your help!

    Regards,
    Kirti
    Last edited by Kirtiraj; 01-21-2011 at 06:47 AM.

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    There are a few ways you can do this.
    It also depends on how you have your data organized.
    If those records share unique ids, its a bit simpler.

    I've attached two transformations that should give you an idea. One considers unique id's, the other compares the key values (A, B and C).

    Cheers,

    Renato
    Attached Files Attached Files

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.