Answer / harry

When we want to get single return value, and also we can
call this anywhere in the mapping

Answer / pooja ahmed

1. When we want to get single return value
2. also we can call this anywhere in the mapping
3. when no.of recs are less go for unconn lkp, which improv
t\da performacesa

Answer / arvind

When we want to get single return value, and also we can
call this anywhere in the mapping
In addition to this it gives u the flexibility to run
lookup for selected source rows which u dont find in
connected lookup

Answer / guduri hari

When we want to get single return value,we can call this
anywhere in the mapping...
> when no.of recs are less go for unconn lkp, which improve
the performancee
unconnect give performance edg

Answer / 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

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

---

What is a design?

1 Answers  

---

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

---

what is lookup ?

7 Answers  

---

---

What is meta data and system catalog?

2 Answers  

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

What are mapping parametres and variables in informatica?

6 Answers   TCS,

---

What is informatica metadata and where is it stored?

0 Answers  

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Can a joiner be used in a mapplet.

1 Answers  

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---