How to recognize zero records in source flat file?I read a flatfile and I should ABORT () if there are no incoming records. How I can do this? The source file is on Unix, so I could use shell scripts, but I would to do this in Informatica....Another questions:can I use Unix pipe as input ("flat")file? A fast method to determine which record I'm processing now? i.e. in the 5th record of the flat file I have to do something special, how to find out this record? ThanksSergej

Interview Candidate
Jan 18th, 2007
3
2331

Showing Answers 1 - 3 of 3 Answers

madhavkash

Jun 22nd, 2007

Register the flat file as source and create a mapping with file as source.
After SQ Txf, create a Filter Txf and make it false to write to a dummy target.
Create a workflow and in that session variable
SrcSuccessRows > 0 True means you have data False means no data