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

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  

---

How do we call shell scripts from informatica?

0 Answers  

---

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

---

explain about informatica server architecture?

1 Answers   IBM,

---

 Informatica Checkpoints

0 Answers   DELL,

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---