Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Dimension Lookup-Update - SCD 2 Problem

  1. #1
    Join Date
    Apr 2015
    Posts
    5

    Exclamation Dimension Lookup-Update - SCD 2 Problem

    Hi ,

    MY Source and Target DB is Mysql

    I have used dimension lookup update step - scd2. In Table Date range end I give default 2199 in "Max.Year" Column. I need to store 2199-12-31 in end_date field . But It stored 2200-01-01.

    Please help me to get result.

    Thanks & Regards.
    Periyadaurai

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Looks like UTC 2199-12-31T23:59:59.999 is displayed as a local time.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2015
    Posts
    5

    Default

    Hi marabu,

    Thanks for reply,

    But I did not get. Please explain deeply. My database is in PST time zone.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    I'll leave deep explanations to somebody else.

    If I see datetime values off no more than half a day I suspect timezones involved.
    Just look at the exact values (date including time) and calculate the difference between the expected value (2199-12-31 23:59:59.999) and your observed value.

  5. #5
    Join Date
    Apr 2015
    Posts
    5

    Default

    Hi Marabu,

    Thanks. Now i got it. Timezone issue only

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.