Answer Posted / sweta kedia

. I) Joiner is active transformation & lookup is passive
transformation.
II) Joiner operates on sources where as lookup operates
source as well
as target.
III)Joiner doesnt support nonequi joins whereas lookup
supports nonequi join
i.e. joiner transformation supports only equality operator
in condition of join where as lookup transformation can
support<=,>=,=,!= in the lookup condition.
IV) Lookup uses dynamic and static cache where as a joiner
doesn’t.
V) Joiner transformation does not match for null values
whereas lookup transformation matches for null values.
VI) Joiner will do left outer,right outer,normal,full outer
types of joins whereas lookup will do only left outer join.

How to load the data from people soft hrm to people soft erm using informatica?

948

---

What is informatica? Why do we need it?

1038

---

how many types of dimensions are available in informatica?

996

---

Explain in detail about scd type 1 through mapping.

1295

---

What is transformation?

1049

---

What is primary and backup node?

1077

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1906

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2206

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1106

---

Which version configuration tool used in ur project?

3180

---

What is decode in static cache?

1075

---

What is expression transformation?

1034

---

What are the different types of repositories created using informatica?

1059

---

Write the prerequisite tasks to achieve the session partition?

1069

---

Can we override a native sql query within informatica?

986

---