1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

0 Answers  

---

What do you understand by active and passive transformations?

0 Answers  

---

how do u implement unconn.stored proc. in a mapping?

1 Answers  

---

What is data cleaning?

0 Answers  

---

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 Answers  

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

0 Answers  

---

we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record

3 Answers  

---

What are three tier systems in etl?

0 Answers  

---

what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  

---

what is pmrep command?

1 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  

---

Difference between flat files and relational sources?

0 Answers   Satyam,

---