- Data Integration
- All Products
if( ($temp.DataTask1[1]/output[1]/Failed_Target_Rows < 0 or $temp.DataTask1[1]/output[1]/Task_Status = '1') and ($temp.DataTask2[1]/output[1]/Success_Target_Rows > 0 and $temp.DataTask2[1]/output[1]/Failed_Target_Rows = 0) and $temp.DataTask3[1]/output[1]/Success_Target_Rows > 0) then 'Pass' else 'Fail'
Property
| Description
|
---|---|
On Warning
| The path that a taskflow takes when it encounters a warning in a Data Task step.
A warning occurs when a Data Task step completes incorrectly or incompletely. For example, you see a warning if the Data Task step copies only 20 out of 25 rows from table A to table B.
You can choose from the following options:
Default:
Ignore
|
On Error
| The path that a taskflow takes when it encounters an error in a Data Task step.
An error occurs when a Data Task step fails. For example, you see an error if the Data Task does not copy table A to table B.
You can choose from the following options:
Default:
Suspend Taskflow
|
Fail taskflow on completion
| The taskflow behavior when the task associated with the Data Task step fails or does not run.
You can configure a taskflow to fail on its completion if the task associated with the Data Task step fails or does not run. If the task fails or does not run, the taskflow continues running the subsequent steps. However, after the taskflow completes, the taskflow status is set to failed.
If you configure both the
Suspend on Fault taskflow advanced property and the
Fail taskflow on completion
property, the
Suspend on Fault property takes precedence. In this case, if the task associated with the Data Task step fails or does not run, the taskflow is suspended. The taskflow does not run the subsequent steps after the Data Task step.
|
It would be helpful to see the possible Task Status Codes; like 1=Success, 2=Warning, 3=Failed etc...
Hi Kiran,
This topic contains the design part of the Data Task step. The codes are documented in the Monitor Guide as we see the codes there. Kindly check https://docs.informatica.com/cloud-common-services/monitor/current-version/monitor/monitoring-data-integration-jobs/monitoring-taskflows/data-task-properties.html.
Thanks,
Informatica Documentation Team
Can you explain how the Job Filter for dynamic mapping tasks should be populated when multiple jobs need to be run? Is this a comma separated list of . values?
Hi Remy,
We’re working to address your comments and will get back to you.
Thanks,
Informatica Documentation team