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.

What is informatica? Why do we need it?

831

---

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

852

---

In warehouses how many schemas are there?

763

---

What are the tuning techniques you applied during your last project

1759

---

I have a flat file, want to reverse the contents of the flat file

882

---

---

Is stop and abort are same in informatica?

735

---

What do you understand by a term domain?

850

---

What is the fact table?

755

---

Enlist the tasks for which source qualifier transformation is used.

760

---

What is the way to execute pl/sql script using informatica mapping?

1198

---

Describe expression transformation?

843

---

Is it possible to create multiple domains on a single Informatica server?

974

---

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

797

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2117

---

Enlist the various types of transformations.

721

---