sending a mail using informatica workflow

Question

I have an informatica mapping-a simple one which has Sq->t(x)->tgt

Here I am populating the target (which is a flat file) only if a certain condition is satisfied, which is included in the transformations.

Now my requirement is that if the target (a txt file) is populated even with even one record it should send out an email to two people.

I am using the mailx Unix command but I am not sure how to check whether there are any records in the target file using Unix script. This is what I have tried:
if [ "/data/informatica/Services/myfolder/TgtFiles/filename.csv" = "1" ]//here i am trying to check if there are any records in the target
then

    mailx -s "Target is populated" "reciepent1@abc.com reciepent2@abc.com "<<ed
    Validation completed
    ed
else
    exit
    eod
fi

Answer 1

It's not clear what shell informatica is calling, but this should work with about any bourne derivative (not csh).

if [ `wc -l < "/data/informatica/Services/myfolder/TgtFiles/filename.csv"` -gt 0 ]
   # //here i am trying to check if there are any records in the target
then
    mailx -s "Target is populated" "reciepent1@abc.com reciepent2@abc.com "<<ed
    Validation completed
    ed
else
    exit
    eod
fi

I can't easily test the mailx part and don't know what eod means for informatica. If I replace the then body with echo yep and the else body with echo nope, it works as expected.

If you can use newer command-substitution , replace the first line with
if [ $(wc -l < "/data/informatica/Services/myfolder/TgtFiles/filename.csv") -gt 0 ]