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
- 10637 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 |
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
How to elaborate powercenter integration service?
What are the components of the workflow manager?
What is mapplet and a reusable transformation?
How will u pas the data with out debugger?
What is a sequence generator transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Teradata 
