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

What is batch and describe about types of batches?

2 Answers  

---

can any one explain me about junk dimension

4 Answers  

---

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

What are the new features of informatica 9.x at the developer level?

0 Answers  

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

How can we use mapping variables in informatica?

0 Answers  

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

---

how to sort date field in infomatica?

2 Answers  

---

Define joiner transformation?

0 Answers  

---