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

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

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

1 Answers   HP,

---

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

How do you take care of security using a repository manager

2 Answers  

---

What are the types of presistent cache in look up tr.

0 Answers   IBM,

---

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

---

what is the necessity to use update strategy?(except for updates)

2 Answers   Emphasis,

---

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

How to extract sap data using informatica?

0 Answers  

---