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


Please Help Members By Posting Answers For Below Questions

What is informatica powercenter repository?

707


How is union transformation utilized?

561


how tokens will generate?

1723


How can one identify whether mapping is correct or not without connecting session?

869


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

588






What is the scenario which compels informatica server to reject files?

598


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?

1497


What is the use of an aggregator cache file?

678


How to extract sap data using informatica?

598


What are batches?

612


What are the differences between source qualifier and joiner transformation?

589


Describe expression transformation?

630


What is the difference between STOP and ABORT options in Workflow Monitor?

689


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

1729


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1650