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.

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1215

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10047

---

Performance tuning( what you did in performance tuning)

1935

---

What is a joiner transformation and why it is an active one?

1025

---

What is joiner change?

1100

---

Could you explain what is enterprise data warehouse?

1082

---

What is pmcmd command?

1061

---

have u done any performance tuning? how u ll do?

2259

---

What is the procedure for creating independent data marts from informatica 7.1?

1029

---

what is mean by complex business rule ?

2129

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2071

---

What are the uses of etl tools?

1083

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7360

---

What are the settings that you use to configure the joiner transformation?

1021

---

Explain your project of banking domian.

1624

---