Answer / mansi

We can override the lookup query for a relational lookup.
We can enter the entire override, or we can generate and
edit the default SQL statement.
Override the lookup query in the following circumstances:
1.Override the ORDER BY statement
2.A lookup table name or column names contains a reserved
word
3.Use mapping parameters and variables
4.A lookup column name contains a slash (/) character
5.Add a WHERE statement

r u done any partitions in ur project?

0 Answers   TCS,

---

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

---

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  

---

how did u understand business requirement?

2 Answers   TCS,

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

---

What happens when a session fails and you click on recover?

0 Answers  

---

is it possible to index the data in cache of lkp transformation ?

0 Answers  

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

---