Answer Posted / swetha

Connected lookup
Unconnected lookup

Receives input values diectly from
Receives input values from the result of a

the pipe line.
lkp expression in a another transformation.

yoU can use a dynamic or static cache U
can use a static cache.

Cache includes all lookup columns Cache
includes all lookup out put ports in the

used in the maping
lookup condition and the lookup/return port.

Support user defined default values Does
not support user defiend default values

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1649

---

Enlist some properties of sessions.

1057

---

How does a rank transform differ from aggregator transform functions max and min?

1192

---

How to use procedural logic inside infromatica?

1206

---

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

1162

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10668

---

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

1053

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2372

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1019

---

write a query to retrieve the latest records from the table sorted by version(scd)

1053

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3855

---

What is mapping debugger?

993

---

Different circumstance which drives informatica server to expel records?

967

---

How to implement security measures using repository manager?

1155

---

Explain constraint based loading in informatica

1076

---