Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 10796 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jaspreet banga
For this we have to make 2 different sessions for each
source reading after the success of first session(i.e.,
succesful reading of 1st source ) , create a 'TOUCH FILE'
using 'command task' and link it with the session, hence
the touch file is only created if the session is
succesful . and at the beginning of another session(reading
second source) create an 'EVENT WAIT TASK' which will only
triggered when touch file is created. and hence you will
get it..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinu
Hi, SUNDHAR,,
Your answer for Data Writen in Targeet Table.
My Question for Source Read.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudhar
If the Source is in different flow then we can use the
Target load order to specify to finish the Flow1 with the
source 1 before starting the flow2 with the Source 2.
| Is This Answer Correct ? | 1 Yes | 5 No |
wht is full process of Information source to target just like stg to productuon and development
What is target update override
what is the size of u r project? and what is the size of source file?
What is the difference between a connected look up and unconnected lookup?
Can informatica load heterogeneous targets from heterogeneous sources?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
What are roles and groups and benefits of using them?
why normalizer transformation can not used in mapplet? plzzzz answer
what is the -ve test case in your project.
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
How can we get multiple output values using an unconnected lookup transformation?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
Teradata 
