Using SQL-> select empid,ename,year,sum(sal) Total_Sal from table

i have a table like
empid ename year month sal
1 x 98 jan 500
1 x 98 feb 500
1 x 98 mar 500
1 x 99 jan 600
1 x 99 feb 600
2 y 98 jan 600
2 y 98 feb 600
2 y 98 mar 600
2 y 99 jan 700
2 y 99 jan 700
and so on
i want to find out totsal for every emp on year wise
plz help me

Question Posted / ankit kansal

4 Answers
11020 Views
Magna Infotech, I also Faced
E-Mail Answers

Answer Posted / ankit kansal

Using SQL->

select empid,ename,year,sum(sal) Total_Sal from table_name
group by empid,ename,year;

Using Informatica->

SRC->SQ->Agg(sum(sal)[group by empid,ename,year])->TGT

http://deepinopensource.blogspot.in/

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What could be the possible resons of locks by user?

1144

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2125

How can you increase the performance in joiner transformation?

1248

Differentiate between Load Manager and DTM?

2214

How union transformation is used?

1057

What is meant by incremental aggregation?

1184

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

4151

How to go to the older version for a mapping?

1157

What is an expression transformation?

1078

Briefly define a session task?

1196

What is meant by a domain?

1189

Explain how to import oracle sequence into informatica?

1071

What is an active transformation?

1159

Explain about cumulative Sum or moving sum?

1092

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

1098