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

Can we override a native sql query within informatica?

0 Answers  

---

What is the reusable transformation?

0 Answers  

---

what are surrogate keys?

5 Answers  

---

What do you mean by worklet?

0 Answers  

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

replace multiple spaces with single space.

3 Answers   IBM,

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

What is the Router transformation?

2 Answers   Informatica,

---

What is the function of look up transformation?

0 Answers  

---