Skip navigation
Contact Us
1175 Views 6 Replies Latest reply: Nov 6, 2012 9:58 PM by Naveen Kumar Dasu RSS
Naveen Kumar Dasu Novice 44 posts since
Feb 20, 2012
Currently Being Moderated

Nov 2, 2012 10:22 PM

How to right the validation logic for the load date field.URGENT..

Hi Guys,

              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...

 

 

Regards,

Naveen

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points