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.

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

What is intricate mapping?

0 Answers  

---

What are the different types of repositories created using informatica?

0 Answers  

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---

Which kind of index is preferred in DWH?

3 Answers  

---

what is semi-additive fact?where did u used?

2 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---