Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 10587 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
What happens when a session fails and you click on recover?
what are cost based and rule based approaches and what is the difference?
how to delete duplicate records by using filter transfermation?
what is the size of your data warehousing?
What are the static cache and dynamic cache in informatica?
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
Can we create out put ports in source qualifier t/r?
tell me the informatica architecture
Define update strategy?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Teradata 
