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

Briefly define reusable transformation?

1079

Write the unconnected lookup syntax?

1033

What are the data movement modes in informatica?

1085

What are the differences between oltp and olap?

923

What is sq transformation?

1083

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2258

How many numbers of sessions can one group in batches?

1018

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2082

What is the meaning of up gradation of repository?

1901

How many transformations can be used in mapplets.

1878

Differentiate between sessions and batches?

968

What is a pre-defined event and user-defined event?

978

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1051

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

1015

what is mean by complex business rule ?

2114