I've a job which includes a sequential file stage and a transformer stage.
Is there any way to get the routine in the transformer executed, if zero rows are passed from the sequential file stage. I've to write the return value from the routine to a target table.
No, don't think it is possible from within the transformer, if the transformer is just following the Sequential file stage. Introduce one more stage in between (may be an IPC) (and try DSGetLinkInfo to get the processed row counts and call the routine to get the value to be written to the target table) and place it to the target table link only if the rows processed count is zero for the sequential file stage.
Success consists of getting up just one more time than you fall.
You can run an after-stage subroutine in which you can check the rowcount or number of rows present in the sequential file and then pass the return value. Makes sense ???
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.