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.
Did you confirm the following:
1. $$LAST_EXTRACT_DT is already part of DAC correct? Why are you manually adding it in the file? As long as it is set in DAC, then it should not require manual addition.
2. Did you confirm custom property for Integration Service overrideMpltVarWithMapVar as Yes
3. Did you make sure the Variable is defined as MAPPING Variable under Parameters?
4. Did you confirm that you are checking the correct PARAM file when you check the WF logs? Does this PARAM file have the right value?
If helpful pls mark correct or helpful.
Hi Please help me with the issue, We have created a four custom informatica mapping and workflow, For incremental load we have using $$CUR_SNAPSHOT_DATE,
This Variable is registered in DAC and Informatica Mapping and Parameters
while running the execution plan in incremental mode , Parameter value is getting passed for two WF's and not for other two workflows and getting null values and Task's are getting failed
In WF log we could not see any value for $$CUR_SNAPSHOT_DATE and its displaying as .
Tried couple of times to delete the Parametrer file.txt and rerun the task, but no luck
Please help me in this regard.