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 the difference between informatica6.1 and infomatica7.1
What is InformaticaPowerCenter?
how tokens will generate?
What will be the approach?
Describe data concatenation?
What is domain in terms of informatica?
What is sq transformation?
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
What is target load order?
How many number of sessions can one group in batches?
What are the different ways to implement parallel processing in informatica?
Can u generate reports in Informatica?
Explain in detail about scd type 1 through mapping.
Difference between Target-based loading and constraint-based loading?
What the difference is between a database, a data warehouse and a data mart?