top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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?

+2 votes
344 views
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?
posted Oct 14, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

(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.

answer Oct 29, 2015 by Manikandan J
Similar Questions
0 votes

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?

+1 vote

My source having 10 records but how can i load 20 records in target, i am not bother about duplicates. How I can do it?

...