Answer / sukanta

Look up will better perform because the cache is initially
created when the first record will reach at Look up
tarnsformation and the further records are work upon the
cached records.Look up will perfrom left outer Join
only.Other Joins can't be posible.You can check the records
are either exists in the lookup table or not.

Jioner will be slower than look up but sorted port
Join,well choosing of Master and detail configuration will
give better performance for Joiner.

Answer / raj

the lookup and joiner t/r can be used to join two sources data.
if u r using one source is flat file and another source is database source then we can use joiner is better.i.e heterogeneous join.it is not possible with the help of lookup.
if two sources are in the same database lookup is better.

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

where to select code page option?

2 Answers   TCS,

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

How can you generate reports in informatica?

0 Answers  

---

Can we create multiple integration service on single repository?

0 Answers  

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

---

I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---