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.
Answer Posted / 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 |
Post New Answer View All Answers
What is update strategy transform?
Is it possible to use a client with different version than that of its Informatica server?
How do you change a non-reusable transformation to reusable transformation?
What are the types of schemas we have in data warehouse.
What is informatica metadata and where is it stored?
What is a mapplet/worklet in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What do you mean by blocking transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How we can create indexes after completing the loan process?
What does role playing dimension mean?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Define update strategy?
Explain the code page compatibility?
what is song in infrmatica...?