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.

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

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

0 Answers  

---

How to start a workflow using pmcmd command?

0 Answers  

---

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

---

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 Answers   Accenture,

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---