Answer / reddy

parcistance cache is one of the cache which is in lookp t/r
It is used in multiple session runs.this improves the
performance.
If we wnat to run the same session more then one time then
we go for percistance cache.

what is parallel querying and what r hints.

1 Answers  

---

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

10 Answers   Cap Gemini, IBM,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?

1 Answers   Altisource, Patni,

---

What is facttable granularity?

2 Answers  

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

what is shared Cache. when we will use shared Cache?

4 Answers  

---

can u give example for factless fact table

2 Answers   TCS,

---

what is mapping performence?

2 Answers   Cap Gemini,

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,

---