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
- 10926 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 |
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
how remove 1st 3 records & last 3 records in informatics
Name the different lookup cache(s)?
Difference Between ETL & ELT?
In which circumstances that informatica server creates Reject files?
wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15
what is the hint? how to use it to reduce the query processing in program?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Can we create a Integration service without a Repository service and vice versa?
Explain target update override in informatica
Teradata 
