Answer / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

Explain sessions?

0 Answers  

---

How can we store previous session logs?

0 Answers  

---

what is mystery dimension?

1 Answers  

---

what is diffrence b/w joner and union transfermation

6 Answers  

---

SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,

---

What are the reusable transforamtions?

1 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,

---