Answer Posted / gopal

In joiner we can join two heterogeneous sources for entire
records based on a condition.

But in look up only the first value or last value of the
records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
EX:
in source : No Name
1 -
Look up table: No Name
1 A
1 B
1 C

Now we can return only A or C in look up.
If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
solution.

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1947

---

How do you set a varible in incremental aggregation

1944

---

What are the types of data warehouses?

1576

---

How can informatica be used for an organization?

1274

---

What is the session task and command task?

1115

---

what is unit testing?tell me proceedure

2275

---

what is Active lock explain

2857

---

What is the benefit of partitioning a session?

1235

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2187

---

How do you load unique records into one target table and duplicate records into a different target table?

1316

---

What is the fact table?

1136

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

---

Explain the use of aggregator cache file?

1317

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2185

---

what is INFORMATICA TESTING process

2334

---