Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-8717

PDI Operations Mart: Wrong date calculation of the duration and execution_timestamp, execution_date_tk, execution_time_tk

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      In the 4 transformations to load the data mart (ETL - Operations Mart ...):
      a) The execution_timestamp is taken from the DEPDATE (see FACT_EXECUTION step). It must be taken from the REPLAYDATE instead.
      b) The duration is calculated by the DEPDATE (see duration + tks step). It must be taken from the REPLAYDATE instead.
      c) The same issue for the execution_date_tk, execution_time_tk (see duration + tks step). It must be based on thee REPLAYDATE.

        Attachments

          Activity

            People

            • Assignee:
              jbleuel Jens Bleuel
              Reporter:
              jbleuel Jens Bleuel
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: