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
- 9712 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 are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
can every transfomation reusable?how?
How to eliminate duplicates in FF and oracle both
Diffrence between static and dynamic cache
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is complex mapping?
In which transformation you cannot drag ports into it?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
Explain sessions. Explain how batches are used to combine executions?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Teradata 
