We are calling a windows batch script in the informatica cloud for preprocessing and post processing commands. but we are unable to pass the exit 1 message to informatica to fail the task. Windows batch script is working fine separately but when the script fails, informatica not able to understand the exit code and always pass the script. In short, informatica task always pass, irrespective whether script pass or fail. Please help !
0
votes
In such scenarios its safe to use event wait. Create an empty file if your processess succeeded. So, i think you need to create a workflow(and import that in infa cloud) then task, task flow and then you can run that with event wait. This is just my 2 cents.
- Koushik
Let me give you brief idea about what i am trying to do. Actually i have take the latest date from control table and compare with the system date. if its not matching then fail the script as well as informatica task but i am able to fail the script not task. informatica task always goes to success.
- rohit
In infa clould you have a function called ABORT('msg'). You can create a mapping as pre-process to check if control date and system date matching or not and abort accordingly.
- Koushik
@Koushik:- thanks for the suggestion!
- rohit
Control table comparison with the system date is post processing activity?
- Mohan Raj
2 Answers
0
votes
