Answer Posted / naresh

If we want to use multiple times in same mapping you can go
for un-connected lookup and It depends on how much data
your processing.

performance wise unconnected lookup is better because its
like reusable one and it will lookup the values only the
condition meet the criteria.

1. It will return only one value
2. It will act as static cache

What is repository manager?

1022

---

Explain the code page compatibility?

1114

---

What is meant by query override?

1112

---

How do you handle two sessions in Informatica

1214

---

Under which circumstances, informatica server creates reject files?

1135

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3750

---

What are the new features of Power Center 5.0?

1845

---

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?

1554

---

What is a predefined event?

1134

---

In warehouses how many schemas are there?

1127

---

What is expression transformation?

1143

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1838

---

How do you update the records with or without using update strategy?

1160

---

How to extract sap data using informatica? What is abap? What are idocs?

1248

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2398

---