Answer Posted / venkatesh reddy

connected lookup:

It is used to join the two tables
it returns multiple rows
it must be in mapping pipeline
u can implement lookup condition
using connect lookup u can generate sequence numbers by
enabling dynamic lookup cache.

unconnected lookup:
it returns single output through return port
it acts as a lookup function(:lkp)
it is called by another t/r.
not connected either source r target.

What is intricate mapping?

1202

---

What is a snowflake schema?

994

---

Differentiate between source qualifier and filter transformation?

1578

---

What the difference is between a database, a data warehouse and a data mart?

1153

---

Define mapplet?

1008

---

What is a grid in Informatica?

1069

---

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

10679

---

difference between repository database and repository service?

1150

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8219

---

Is it possible to create multiple domains on a single Informatica server?

1239

---

Name the different lookup cache(s)?

1232

---

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?

1508

---

What do you understand by SOA of Informatica?

984

---

What are the informatica performance improvement tips

1093

---