I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read

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 Posted / srinu

4 Answers
10934 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / penguin

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

Regards
Penguin

Is This Answer Correct ?

4 Yes

1 No

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

Answer / jaspreet banga

For this we have to make 2 different sessions for each
source reading after the success of first session(i.e.,
succesful reading of 1st source ) , create a 'TOUCH FILE'
using 'command task' and link it with the session, hence
the touch file is only created if the session is
succesful . and at the beginning of another session(reading
second source) create an 'EVENT WAIT TASK' which will only
triggered when touch file is created. and hence you will
get it..

Is This Answer Correct ?

1 Yes

0 No

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

Answer / srinu

Hi, SUNDHAR,,

Your answer for Data Writen in Targeet Table.
My Question for Source Read.

Is This Answer Correct ?

0 Yes

0 No

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

Answer / sudhar

If the Source is in different flow then we can use the
Target load order to specify to finish the Flow1 with the
source 1 before starting the flow2 with the Source 2.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer