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....

How would you join a node to the already existing domain?

1175

---

What is the Rank index port in Rank transformation?

1102

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1553

---

expain about the tune parameters?

2453

---

What is a dimensional model?

1031

---

How do you convert single row from source into three rows into target?

1208

---

How to create a non-reusable instance of reusable transformations?

1166

---

What is meant by a domain?

1182

---

What does reusable transformation mean?

1188

---

What is primary and backup node?

1169

---

What is Index Caches size?

1160

---

what is the Default Source Option For Update Strategy Transformation?

1280

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5780

---

Explain the scenario which compels informatica server to reject files?

1203

---

What are ETL Tools?

1167

---