Answer Posted / nag

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

Explain informatica architecture - version 8 / 9

1039

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2009

---

How to create Target definition for flat files?

1168

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1454

---

can we override a native sql query within informatica? Where do we do it?

1080

---

What are the limitations of joiner transformation?

1055

---

Write the unconnected lookup syntax?

1042

---

What are the types of data warehouses?

1442

---

how to load dimension table and fact table. plz tell me the steps.

2045

---

How can we use batches?

976

---

What is option by which we can run all the sessions in a batch simultaneously?

1087

---

What is the difference between informatica 7.0 and 8.0?

958

---

Define Pmrep command?

1004

---

Write the program through which the records can be updated?

943

---

Enterprise data warehouse your projects phase by phase explain?

1869

---