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

how to work with mapplet designer in informatica?

7 Answers  

---

How would you copy the content of one repository to another repository?

0 Answers  

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

---

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

Parameter and variable differences

0 Answers  

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  

---