Answer / mike

The informatica server builds a cache in the memory when it
process the first row of a cached lookup transformation.It
allocates the memory based on the amount you configure in
the trandformation or session properties.The informatica
server stores the conditional values in the index cache and
data values in the data cache..
correct me if i was wrong

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,

---

Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

i have 2 session s1 execute s2 load first session fail what is the reason?

1 Answers   L&T,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

How to do unit testing in informatica?

1 Answers  

---

What is the capacity of power cube?

1 Answers  

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

what is system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---