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
Tell me about Propagate functions in informatica
Is it possible to revert a global repository to local one and why?
What are the tasks that source qualifier perform?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What do you mean by worklet?
Differentiate between sessions and batches?
How to generate sequence numbers using expression transformation?
Differentiate between a database and data warehouse?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is lookup change?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain about Informatica server process that how it works relates to mapping variables?
What are the different options available for update strategy?
What do think which one is the better joiner or look up?