When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

0 Answers  

---

Which is the t/r that builts only single cache memory?

0 Answers  

---

what is data driven?

1 Answers  

---

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---