Answer / swetha

The informatica server builds a cache in memory when it
processes the first row af a data in a cached look up
transformation. It allocates memory for the cache based on
the amount you configure in the transformation or session
properties. The informatica server stores condition values
in the index cache and output values in the data cache.

Answer / swam

Yes..that's perfect answer from Swetha.

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

0 Answers  

---

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---

---

what is unique constraint error ?

2 Answers   TCS,

---

What do you mean by filter transformation?

0 Answers  

---

what is parallel querying and what r hints.

1 Answers  

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,

---

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

3 Answers  

---