Answer / mike

Yes joiner transformation has cahches. It joins the data
based on master detail joining condition. It first reads
the master source and stores it in the joiner cache and it
reads the detail source and joins with the data in the
joiner cache based on the master detail joining condition.

correct me if i was wrong

Answer / krish

Caching Master Rows
When the Integration Service processes a Joiner
transformation, it reads rows from both sources concurrently
and builds the index and data cache based on the master
rows. The Integration Service then performs the join based
on the detail source data and the cache data.
ur right buddy

Different circumstance which drives informatica server to expel records?

0 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

How will you display "Mr" for male & "Mrs" for female in target table?

7 Answers  

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

can any one explain me about junk dimension

4 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,

---

What is a pre-defined event and user-defined event?

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---