Answer / swetha

Load manager Process: Starts the session, creates the DTM
process, and sends post-session email when the session
completes.

The DTM process. Creates threads to initialize the session,
read, write, and transform data, and handle pre- and
post-session operations.

Answer / rekha

LOAD MANAGER : LOAD MANAGER IS THE FIRST COMPONENT NEEDS TO
BE INITIALIZES WHEN THE SESSION IS SUBMITTED TO THE SERVER
LOAD MANAGER MANAGES THE LOAD ON THE INFORMATICA SERVER BY
MAINTAINING A QUEUE OF SESSIONS AND RELEASES THE SESSIONS
BASED ON FIRST COME FIRST SERVE
ONCE THE LOAD MANAGER RELEASES THE SESSION IT
INTIALIZES THE DTM PROCESS
DTM FOLLOWS THE INSTRUCTIONS CODED IN THE SESSION
MAPPING ,FOR EACH SESSION DTM CRAETES READER ,WRITER AND
SHARED MEMORY

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

How to improve the session performance in informatica?

3 Answers   Accenture,

---

Hi experts, can anyone tell how much we use plsql in real time

3 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---

How we can create indexes after completing the loan process?

0 Answers  

---

What is the difference between view and materialised view?

4 Answers  

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

what is sql override?what is the use of it?

4 Answers   Sonata,

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

What are the differences between oltp and olap?

0 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---