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.

Explain incremental aggregation in informatica

1134

---

Whats there in global repository

1696

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1082

---

What is workflow manager?

1053

---

State the limitations where we cannot use joiner in the mapping pipeline?

1068

---

can you please explain me pre session and post session options?

7575

---

What is lookup change?

1052

---

What is the command used to run a batch?

1067

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2200

---

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?

10175

---

Please let me know how to make Data masking in informatica..

1729

---

Mention few power centre client applications with their basic purpose?

952

---

How do you set a varible in incremental aggregation

1892

---

Explian the Process of deployment groups in informatica

1062

---

draw informatica architecture 8.6 ?

3874

---