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.

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

More Informatica Interview Questions

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,


Explain the shared cache and re-cache?

0 Answers  


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  


What are the active and passive transforamtions?

2 Answers  






Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  


Enlist the tasks for which source qualifier transformation is used.

0 Answers  


What are the reusable transforamtions?

2 Answers  


what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  


Describe an informatica powercenter?

0 Answers  


What is complex mapping?

0 Answers  


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


Categories