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

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

---

what is target load plan

2 Answers   Cap Gemini,

---

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

---

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

---

---

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

---

what are the Methods For Creating Reusable Transformations?

0 Answers   Informatica,

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

Define joiner transformation?

0 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

how to we create datamart?

2 Answers   HSBC,

---

surrogate keys usage in Oracle and Informatica?

5 Answers   ITC Infotech, Oracle,

---