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

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation

1 Answers   TCS,

---

Can we create a Integration service without a Repository service and vice versa?

0 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

---

What are active transformations.

0 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

What are the components of Informatica? And what is the purpose of each?

0 Answers   Informatica,

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

How can we store previous session logs?

0 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---