Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Problem with Dimension Lookup/Update Step in 3.2.0

  1. #1

    Question Problem with Dimension Lookup/Update Step in 3.2.0

    i have a problem with the dimension lookup/update step in PDI 3.2.0
    with the version date fields stored in the dimension table

    my input are 3 rows:
    row 1:
    OBJID: 2128
    DATE: 01-01-1900
    CONTENT: 3
    row 2:
    OBJID: 2128
    DATE: 01-01-2005
    CONTENT: 13
    row 3:
    OBJID: 2128
    DATE: 01-01-2008
    CONTENT: 13

    I have set the step to create a version at the change of CONTENT
    for the OBJID and have set the stream date field to DATE

    In this sample, i expect to get 2 rows in the dimension table:
    Version 1 valid from 01-01-1900 to 01-01-2005
    Version 2 valid from 01-01-2005 to 01-01-2200 (my max date)

    but i get the following 2 rows:
    Version 1 valid from 01-01-1900 to 01-01-1900
    Version 2 valid from 01-01-1900 to 01-01-2200

    in 3.1.0 i got the rows as i expected.

    am i doing something wrong or is this somwhow bug??

  2. #2

    Default

    is there anybody out there who is using 3.2.0 and the dimension lookup/update step?

    i use it and it doesn't work, i found my problem meanwhile,
    it seems an old bug is back, which is very ugly ...

    "the used stream date is only taken from the first record, then never again"

    http://jira.pentaho.com/browse/PDI-490
    http://forums.pentaho.org/showthread.php?t=58112

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

    Default

    It's more likely it has something to do with that 1900-01-01 "changed date".
    In any case, either re-open the JIRA case or file a new one with a sample transformation attached.

    Thanks in advance,
    Matt

  4. #4

    Default

    did that already, attached samples now

    http://jira.pentaho.com/browse/PDI-2526

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

    Default

    Thanks a lot!

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.