Answer Posted / suneel reddy

Answers 1:
Depending upon the scenario we use the conn and unconn tr..

for e.g
In u r mapping u require same lkp multiple times, creating
lkp multiple times put it in flow is not a good idea, which
occupies more cache ...
Instead of that create one unconnectes lkp use multiple
times where ever u want , which very fast..

Answers 2:
u can use conn lookup but if u need 1 row so go for unconn
lookup coz u can
use it multiple time in same mapping from multiple
expression trn.
i hope it will help to u

Can u generate reports in Informatica?

1145

---

What is a filter transformation and why it is an active one?

1016

---

What is sorter transformation?

1111

---

How to elaborate powercenter integration service?

1175

---

What is the maplet?

1205

---

Is there any target staging area in informatica not staging area

2631

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1139

---

What is dynamic cache?

1086

---

How to use pmcmd utility command?

1077

---

What is the difference between a repository server and a powerhouse?

1578

---

Difference between Data and Index Caches?

1207

---

What is data caches/ index caches?

1174

---

What is the session task and command task?

1115

---

How to join three sources using joiner? Explain though mapping flow.

1191

---

How to use procedural logic inside infromatica?

1323

---