Answer / san

Just run the session once, and check for the session logs
you will get the DATA and IDX cache size.
Regards,
San

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

5 Answers  

---

what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.

2 Answers   IBM, Tech Mahindra,

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

What is Data Vault???

0 Answers  

---

Can u access a repository created in previous version of Informatica?

1 Answers   DELL,

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers  

---

Explain me ETL project architecture in Detail?

0 Answers   Infosys,

---

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 Answers  

---

What is partitioning? Explain different types of partitioning?

0 Answers  

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

---

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 is session partitioning?

1 Answers  

---