Answer / lvpr

If the lookup condition is same for both mappings, then
make lookup t/r as reusable t/r

Answer / sathish

create lookup using transformation developer then you can reuse same lookup in any times

Answer / usha

we can reuse the LKP in different mapping...

wat we need to do is..

step1:--create a LKP in transformation designer..

if we cerate a transformation in transformation developer
its reusable...

step2:-- create a transformation ...click--->transformation
tab--->changeto reusable

Explain what is informatica metadata and where is it stored?

0 Answers  

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---

Explain the informatica workflow?

0 Answers  

---

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,

---

How the Informatica Server reads perameter file?

1 Answers  

---

---

how to get the only updated records in the target

2 Answers  

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

What is informatica? Why do we need it?

0 Answers  

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

Which files are created during the session rums by informatics server?

0 Answers  

---