4 Replies Latest reply on Jan 14, 2013 1:57 AM by 984573

    Unable to pass parameter($$LAST_EXTRACT_DATE) value to custom mapping

      We have created a custom informatica mapping and workflow

      For incremental load we have used $$LAST_EXTRACT_DATE in our query in source qualifier.

      A separate task is created for this workflow in DAC.

      while running the execution plan in incremental mode , value is not passed for $$LAST_EXTRACT_DATE .

      In session log we could not see any value for $$LAST_EXTRACT_DATE.

      This is the only parameter used in our mapping.

      Made entry for this task in parameterfileOLTP.txt file.
      Separate parameter file is created for this.In this parameter file we are able to see value for $$LAST_EXTRACT_DATE.

      Please help us in this regard.