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
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
What do you understand by a term domain?
What is the scenario which compels informatica server to reject files?
What are the components of workflow manager?
What is rank index in rank transformation?
What do you understand by term role-playing dimension?
What is the reusable transformation?
How to update a particular record in target with out running whole workflow?
Explain the code page compatibility?
Can we override a native sql query within informatica?
What are the various types of transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the fact table?
How might you approve all mappings in the archive all the while?
Separate from a database, an information bazaar, and an information stockroom?