Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 11023 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / vikneswaran
use agg trans group by empid and year then use sum(sal)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is the format of informatica objects in a repository?
How big was your fact table
What are the different ways to implement parallel processing in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
what is mean by complex business rule ?
What is an expression transformation in informatica?
How many ways a relational source definition can be updated and what are they?
What is a predefined event?
where to store informatica rejected data? How to extract the informatica rejected data?
How to create or import flat file definition in to the warehouse designer?
What is depict expression change?
What is exclusive and normal mode for repository services?
What differs when we choose the sorted input for aggregator transformation?
Define mapplet?
