We can use a query, Select dep_id, sum(salary) from emp group by dep

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?

Question Posted / sahil

Answer Posted / sahil

We can use a query,

Select dep_id, sum(salary) from emp group by dep_id;

Here I am using group by because we might have other dep as well.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is update strategy transform?

1116

What is joiner change?

1152

What are the limitations of joiner transformation?

1114

Under what condition selecting sorted input in aggregator may fail the session?

1128

How to use procedural logic inside infromatica?

1250

Explain lookup transformation source types in informatica

1105

What are the types of data warehouses?

1528

Describe an informatica powercenter?

1131

What is the advantage of informatica?

1069

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1067

Can we override a native sql query within informatica?

1045

How to do unit testing in informatica? How to load data in informatica ?

1131

What is deployment group?

1221

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2130

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4115