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

what is work of PUSH DOWN option

2 Answers   Wipro,

---

explan ur project architecture?

0 Answers   TCS,

---

Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,

---

What is the need of etl tools?

0 Answers  

---

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

---

Types of error logs in Informatica?

2 Answers  

---

What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

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

0 Answers  

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  

---

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---