I have one requirement like this.I have a table like MYST_STG."/BIC/OHZAGGARCH" with one field "/BIC/ZLOADDATE".This is a source table incoming from SAP source system into informatica. We have a one to one map for this in informatica.Now the requirement is the Load date field contains data say 20110926.If the field conatins previous month data other than the current month data say 20110815 it should identify the data raise the red flag and abort the workflow.How can we right the logic for this.Its a new enhancement work for the existing worklow.The workflow contains 3 sessions we need to include this logic in between first 2 sessions.i think we can right an Unix script and call the script through command task in workflow.If it is correct please provide me the logic.Can any one help me on this.Its pretty Urgent..Suggestions are welcomed...
Can any one please help me on this..
You can easily achive this using abort function in expression transformation. Create a port (month_extract) and extract the month (5th and 6th position ) values from the date fileds and compare it with the system month (systemmonthextract) in an expression like below.If it match the system month then allow the records ,if not then execute the abort command and throw the message.
IIF(month_extract< systemmonthextract, ABORT('Data is not on current month'))
Thanks for you help i will check on it and let you know for any issues meanwhile can you see the requirement sheet attached so that there is one more similar task need to be done.Please check it and help me on this as well.
What is the value in systemmonthextract i need to provide is that sysdate.
Yes Naveen,Get the system date and extract the month from the date.
For the second scenario..Create a mapping and session and extract the MM ( 09 or 11) from the BIC/Z9VERSION feild and allow only the records which is lesser than current month ( for gettting current month use sysdate).
In the workflow link this session to a email task and trigger this email task when the TGT.recordcount > 0 .
Please check the following Exp what i had done.
But i am getting error in validating the Expression of O_BIC_ZLOADATE.Can you please check the error and let me know.