Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: What is the purpose of the Date tab in the transformation properties?

  1. #1
    Join Date
    Aug 2008
    Posts
    563

    Default What is the purpose of the Date tab in the transformation properties?

    Hi,
    I tried to find out what the date tab in the transformation properties is for, but couldn't find more info than this.

    Is this used for CDC? Is there an example on how to use this?

    Thanks!
    Best regards,
    Diethard
    ===============
    Visit my Pentaho blog which offers some tutorials mainly on Kettle, Report Designer and Mondrian
    ===============

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

    Default

    You can use these settings to influence the calculation of a Change Data Capture (CDC) date range. By default the date range is:
    • from: the last time the transformation ran correctly (based on the transformation log table)
    • to: the execution date of the current transformation. (the upper limit mentioned in the doc)


    You can get both values from step "Get System Info".

    HTH,
    Matt

  3. #3
    Join Date
    Aug 2008
    Posts
    563

    Default

    Thanks a lot Matt for the info! I put together a short article explaining CDC and logging here on my blog.
    Best regards,
    Diethard
    ===============
    Visit my Pentaho blog which offers some tutorials mainly on Kettle, Report Designer and Mondrian
    ===============

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

    Default

    Great blog post Diethard!

  5. #5
    Join Date
    Aug 2008
    Posts
    563

    Default

    Thanks a lot Matt! I also included your and Jos' fantastic feedback and added an example. I hope this is now more useful! The update article is now available here.
    Best regards,
    Diethard
    ===============
    Visit my Pentaho blog which offers some tutorials mainly on Kettle, Report Designer and Mondrian
    ===============

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.