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

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

what we require for D.modelling?

1 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  

---

To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,

---

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

---

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

---

A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

why we need informatica

2 Answers   HCL,

---