A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either ‘Yes’ or ‘No’. How do you assign the value to the $NEEDS_RECOVERY variable?

A SAP Data Services job contain logic to execute different dataflows depending on whether the job was successful or failed. Therefore the $NEEDS_RECOVERY variable should be set to either ‘Yes’ or ‘No’. How do you assign the value to the $NEEDS_RECOVERY variable?
A . Use a script with an SQL function to read from status table
B . Use a catch block and set the variable to ‘yes1
C . Use a dataflow to set the value via a template table
D . Use a global variable to persist the value across job executions

View Answer

Answer: B