Answer / isha

Yes.

Uncheck the 'lookup cache enabled" option. It will become un-cached lookup and will fire query on DB directly... It is not a good idea at all. Cache always increases speed of execution.

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Explain the use of aggregator cache file?

0 Answers  

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

---

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  

---

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

---

---

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers  

---

What is confirmed dimension?

3 Answers  

---

how remove 1st 3 records & last 3 records in informatics

4 Answers   TetraSoft,

---

how to insert header after each group.

1 Answers   IBM,

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

What is expression transformation?

0 Answers  

---

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

---