Answer / hari

use order by clause in source qualifier.
Remove un necessary ports in that lookup.
try to restrict lookup cache based on the source data.
create order by clause in lookup override using the lookup
condition columns.
If lookup and source are in same database try to join in
source qualifier.
Drop the indiex on the target table before loading the data.
Check index on source table,
Check source table look tables are analysed properly or not.

Answer / murali udayagiri

One more point we can add to the first answer.
i.e
Check lookup condition columns are having indexes or not.
If indexes are present check when those are rebuild.Index
snaps are old then rebuild them before going to be start
session.If indexes are not present on conditional columns
just create.

Please let me know if any issues.

Thanks,
Murali Udayagiri

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?

3 Answers   ACS,

---

How is Data Models Used in Practice?

1 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

Can we override a native sql query within informatica?

0 Answers  

---

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,

---