This discussion is archived
4 Replies Latest reply: Jan 13, 2013 5:57 PM by 984573 RSS

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

user6347009 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points