Answer Posted / dharmendra

SOURCE->SRT->EXP->AGT->TGT

SRT - Sort by column col1.
EXP - empid
name
v_name=iif(v_empid=empid,v_name||','||name,name)
v_empid=empid
o_empid=v_empid
o_name=v_name
After this we can use aggregator t/r to take last row for a
particualr emp id using LAST.

Can you generate sequence numbers without using the sequence generator transformation?

1163

---

In which transformation you cannot drag ports into it?

1381

---

Which development components of informatica have the highest usage?

1099

---

where to store informatica rejected data? How to extract the informatica rejected data?

1057

---

What are data-driven sessions?

1261

---

Enlist few areas or real-time situations where informatica is required.

1141

---

What is a pre-defined event and user-defined event?

1083

---

What is aggregator transformation in informatica?

1006

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2085

---

Performance tuning( what you did in performance tuning)

2058

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---

tell me 5 session failure in real time how can you solve that in your project?

2393

---

explain about unit testing? in real time?

2265

---

Do you find any difficulty while working with flat files as source and target?

1149

---

How to implement security measures using repository manager?

1244

---