Answer / nikhil

Using lookupoverride u can join two relational tables but
not flat files . Joniner T is used to join two heterogenous
sources like relational tables from two different databases
or flat file sources.

Answer / kotesh

using lookup override we can join more two table either it
is relational or flatfiles also. and one more advantage is
it supports orderby condition.
but jointrns we can join two tables.

Answer / joshasmita

Using Loopoverride we can join two relational tables but
from same database. With joiner we can two sources of
different types

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

What are the rank caches?

2 Answers   Informatica,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

0 Answers   Informatica,

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---