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 informatica powercenter repository?
How is union transformation utilized?
how tokens will generate?
How can one identify whether mapping is correct or not without connecting session?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the scenario which compels informatica server to reject files?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the use of an aggregator cache file?
How to extract sap data using informatica?
What are batches?
What are the differences between source qualifier and joiner transformation?
Describe expression transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the validations that you can perform in oracle and in informatica ? Advance Thanks