Passing Value of Mapping Variable to Workflow Variable
Declare a Mapping Variable
Assign it in expression, this will be used at the workflow level. If the Variable assigned is 1, then we move forward with the ETL execution else write the data into Error tables and fail the File which is currently being Processed.
Declare a Mapping Variable
Assign it in expression, this will be used at the workflow level. If the Variable assigned is 1, then we move forward with the ETL execution else write the data into Error tables and fail the File which is currently being Processed.
Create Variable at the Workflow Level, Workflows --> Edit--> Variable
Pre-Session Variable Assignment
Post - Session Variable Assignment
Control ETL workflow Execution based on the variable values, in this case the next session is triggered. Happy Path!
Negative Case: Error Session is triggered.
No comments:
Post a Comment