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

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..

Answer / srinu

Hi, SUNDHAR,,

Your answer for Data Writen in Targeet Table.
My Question for Source Read.

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.

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

---

What are the two modes of datamovement in informatica sever?

2 Answers  

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

What is galaxy shema

2 Answers   CGI,

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

---

What are the tasks that can be performed using sq?

0 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---