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
mailx -s "Target is populated" "email@example.com firstname.lastname@example.org "<<ed