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

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

Types of error logs in Informatica?

2 Answers  

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  

---

What is target update override

2 Answers   CTS,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

How do you load only null records into target?

0 Answers  

---

Why we use ENABLE HIGH PRECISION in session properties?

2 Answers   Cognizant,

---

how to use incremental load?

2 Answers   TCS,

---