Answer Posted / sukanta

Lookup-

Let suppose you have empno in your source table but the
empno,address,name etc are stored in a lookup table and you
want all detail of employee will be go to target,then look
up is better option.

Lookup is passive transformation and support join on lookup
table basis of src.empno=lkp.empno(+).that means if in the
lookup table not have the source coming empno then it will
return null value for lookup empno.

so let suppose the lookup table is the target table in your
mapping,then you can find out the target table exists the
source record or not.

Joiner

If you want, the join condition satisfied,then the
satisfied all rows should go for next then join condition is
mandatory.Lookup can't do that.

Previous is posted by me.

Regards

Sukanta

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

2400

---

What is union transformation?

966

---

wf dont have integration severances how you can run?

1941

---

What are the modules in Power Center

1680

---

Explain what transformation and how many are there in informatica?

960

---

Enlist few areas or real-time situations where informatica is required.

1088

---

What are the tasks that source qualifier perform?

1106

---

What is the function of union transformation?

1137

---

How to extract sap data using informatica? What is abap? What are idocs?

1183

---

Briefly explain the aggregator transformation?

1010

---

If informatica has its scheduler why using third party scheduler?

1268

---

EXL informatica Questions

1394

---

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?

1173

---

Explain in detail scd type 2 through mapping.

1045

---

Explain about Informatica server process that how it works relates to mapping variables?

1084

---