Answer Posted / sweta kedia

A. Connected Lookup
Receives input values directly from the pipeline.
We can use a dynamic or static cache
Supports user-defined default values

Unconnected Lookup
Receives input values from the result of a :LKP expression
in another transformation.
We can use a static cache
Does not support user-defined default values

When you compared both basically connected lookup will
return more values and unconnected returns one value. conn
lookup is in the same pipeline of source and it will accept
dynamic caching. Unconn lookup don't have that faclity but
in some special cases we can use Unconnected. if output of
one lookup is going as input of another lookup this
unconnected lookups are favourable
Moreover if the mapping requires multiple lookup using same
lookup conditions then its better to use unconnected lookup
& call the lookup wherever required.This also prevents the
mapping from being complex.

What are the measure objects?

927

---

What happens when a session fails and you click on recover?

888

---

Explain direct and indirect flat file loading (source file type) - informatica

1098

---

What are Dimensional table?

835

---

If informatica has its scheduler why using third party scheduler?

1035

---

Which is the t/r that builts only single cache memory?

971

---

Is there any way to read the ms excel datas directly into informatica?

791

---

Could you explain what is enterprise data warehouse?

788

---

What are pre and post-session shell commands?

1033

---

tell me about your project functionality

2121

---

How we can create indexes after completing the load process?

954

---

can u any challenge your project?

1822

---

how we can load rejected record's at run time?(not through bad files)

2160

---

Briefly define reusable transformation?

865

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1843

---