Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rec count of flat file and if count>0 then the next session will run

Status
Not open for further replies.

etlp

Programmer
Sep 20, 2007
1
CA
Hi,
I have a flat file generated from the previous session in the Informatica workflow and if the generated flat file has record count>0 then the next subsequent session needs to be run or else faliure mail needs to be send.
How can i acheive this.Any help in this regard will be appreciated.

Thank you
 
Set the link properties to the next session for target rows > 0 and the link to the failure email to target rows = 0.

"I think we're all Bozos on this bus!" - Firesign Theatre [jester]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top