I have 2 Sources, If 1st one Read sucessfully,Then only it has to move to read 2nd source? How can i do in informatica?

Question

I have a directory of files where each file is in one of three file formats. We can use the filename to determine the file format for mapping data. I would like to loop through all the files in the directory and based on the filename direct it towards the associated session mapping, delete the file on success, update the control table and then move to the next file. I'd like the execution to be deterministic. What are some of my options?

Answer 1

(a) If we do it in 2 different sessions, the link condition in the WF can be given based on TgtSuccessRows >0 .
(b) If we do it in the same session hence same mapping, we can split into 2 pipelines after the 1st pipelines reads from Src1, it will be followed by 2nd piepline reading from Src2.