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

We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  

---

How to view and Generate Metadata Reports?

1 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

Could any one to tell Fact table Partitioning?

2 Answers  

---

Name 4 output files that informatica server creates during session running?

1 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---

connected and unconnected lookups?

4 Answers  

---

what is the difference between stop and abort?

3 Answers   TCS,

---

What is workflow manager?

0 Answers  

---

What is aggregator transformation in informatica?

0 Answers  

---