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

In which transformation you cannot drag ports into it?

1374

---

What is session task and command task?

1391

---

How does the aggregator transformation handle null values?

1192

---

What are the issues you have faced in your project? How did you overcome those issues?

2410

---

What is mapping debugger?

1067

---

What are the different versions of informatica?

1332

---

Explain lookup transformation is active in informatica

1146

---

What is sequence generator transformation in informatica?

1120

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4147

---

Define the various join types of joiner transformation?

1039

---

What is meant by LDAP users?

1282

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2181

---

How to update a particular record in target with out running whole workflow?

1622

---

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2792

---

How to configure mapping in informatica?

1222

---