Answer / srinu

Look up Transformatoin only,
its going to maintain existing data also in cach memory

Answer / subhransu,bangalore

costly means consuming more memory.which transformation have cache memory.
example:lookup TR
sorter TR
aggregator TR
rank TR
joiner TR

Answer / soujanya

costliest means occupying more memory.
filter
sorter
aggregator
rank
lookup
the transformations having cache memory

what is the gap analysis?

1 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

---

Define mapping and session?

0 Answers   Informatica,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

---

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 Answers  

---