Answer Posted / srikanth nallapati

if we are not using group by also u get the result from agg
traceformation but u get only one one total column result

Ex:deptno sal
10 1000
20 3000
30 4000
10 5000
in aggr trance i am not use group by but i create one new
column like sum_of_sal here logic implementation is sum(sal)
this sum sal is linked with target table then u get result
as like above description.... if u try to send more then
one column from this aggre tranc means it's fail..

i think it's work....

What are active transformations.

1648

---

How will the document be delivered to me?

1067

---

What are the popular informatica products?

1006

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1150

---

How to handle decimal places while importing a flatfile into informatica?

1187

---

How to load last n records of file into target table - informatica

1065

---

How many numbers of sessions can one group in batches?

1060

---

what is the hint? how to use it to reduce the query processing in program?

7803

---

What is data caches/ index caches?

1094

---

How to create Target definition for flat files?

1211

---

How can repository reports be accessed without sql or other transformations?

1209

---

What is difference between a gateway node and worker node?

1130

---

What are the different transaction levels available in transaction control transformation?

1191

---

What is repository manager?

984

---

What is the advantage of informatica?

1065

---