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

Why sorter is an active transformation?

1191

Explain transaction control transformation in informatica

1268

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2184

can we override a native sql query within informatica? How do we do it?

1126

generate date / time dimension in informatica

1125

What is joiner change?

1146

What is the benefit of partitioning a session?

1182

What is the command used to run a batch?

1062

Define pmcmd command?

1042

How do you set a varible in incremental aggregation

1891

Can you generate sequence numbers without using the sequence generator transformation?

1119

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

1192

How can you increase the performance in joiner transformation?

1190

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1900

Design time, run time. If you don't create parameter what will happen

1837