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
  • 1
  • 2403

Showing Answers 1 - 1 of 1 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.