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
10891 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 is a connected transformation?

1128

What is a passive transformation?

1110

what is $$$$?

2163

How we can create indexes after completing the load process?

1164

What is the status code in stored procedure transformation?

1186

How to start a workflow using pmcmd command?

1257

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10690

What are the databases that informatica can connect to windows?

1059

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1161

What is aggregate cache in aggregator transformation?

1151

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1130

What is the maplet?

1131

what is INFORMATICA TESTING process

2301

Enlist the differences between database and data warehouse.

1127

How many ways are there to do 'remove duplicate records in informatica'?

1021