Answer / suraj kedia

Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....

So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.

Answer / vikram

when thre are no group by or any other calculations required

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

What are the new features in Informatica 5.0?

1 Answers  

---

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

0 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

Which is costliest transformation? costly means occupying more memory?

3 Answers  

---