Answer / swetha

When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.

Answer / atiric sofrware(raja)

joiner caches are data cache and index cache data cache.

data cache that holds the master table rows and the index
cache which holds the join columns from the master table

Answer / soujanya

the joiner transformation creates join cache for master
source. from joiner cache the the joiner transformation
compares with detail source.
the joiner cache always uses master source for better
performance bcoz master source has less no. of records.
cache is the temporary memory

What do you mean by blocking transformation?

0 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

2 Answers   iGate, Qualcomm,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,

---

In a table, 4 person having same salary. How to get Third person record only?

15 Answers  

---

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

---

What are the reusable transforamtions?

1 Answers  

---

what is constraint based loading

2 Answers   IBM,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

Define informatica repository?

2 Answers   Wipro,

---