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

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

1185

---

What is meant by active and passive transformation?

1121

---

What is the difference between stop and abort in informatica

1088

---

expain about the tune parameters?

2410

---

What is primary and backup node?

1123

---

How to create a non-reusable instance of reusable transformations?

1116

---

Plz can any one say me how to get the informatica certification materials and dumps

2044

---

What is a router transformation?

1117

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1104

---

Define enterprise data warehousing?

1197

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2129

---

What do mean by local and global repository?

1224

---

What is dimensional table? Explain the different dimensions.

1168

---

What is data caches/ index caches?

1097

---

explain one complex mapping with logic? sales project?

6663

---