Answer Posted / eswar

Use the Joiner transformation to join source data from two
related heterogeneous sources residing in different
locations or file systems. You can also join data from the
same source. The Joiner transformation joins sources
with at least one matching column. The Joiner
transformation uses a condition that matches one or more
pairs of columns between the two sources.

Use a Lookup transformation in a mapping to look up data in
a flat file, relational table, view, or synonym.The
Integration Service queries the lookup source based on the
lookup ports in the transformation and a lookup condition.
The Lookup transformation returns the result of the lookup
to the target or another transformation.

The Joiner transformation supports only equi joins and
Lookup Transformation supports equi and non-equi joins

The Joiner transformation lieterally joins two columns
whereas Lookup transformation return a column based on the
condition, but it will not joint two columns.

can we override a native sql query within informatica? Where do we do it?

1131

---

How can we use batches?

1031

---

what is the hint? how to use it to reduce the query processing in program?

7853

---

What is primary and backup node?

1137

---

What is the Process to creating lookup transformation in informatica

1052

---

What is target load order?

1253

---

What is option by which we can run all the sessions in a batch simultaneously?

1152

---

What is the use of source qualifier?

1145

---

What is a standalone command task?

1209

---

Differentiate between a repository server and a powerhouse?

1129

---

Can informatica load heterogeneous targets from heterogeneous sources?

1192

---

What are the types of presistent cache in look up tr.

2058

---

What is the reusable transformation?

1054

---

Reusable transformation and shortcut differences

1846

---

What are roles and groups and benefits of using them?

1060

---