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

tell me the push down optimization

2 Answers   Wipro,

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

what is the size of your data warehousing?

1 Answers   IBM,

---

How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

---

Whats there in global repository

1 Answers  

---

How does a sorter cache works?

1 Answers  

---

Why you use repository connectivity?

3 Answers   Yash Technologies,

---

What is aggregate cache in aggregator transformation?

1 Answers   Informatica,

---