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
- 10890 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
Scheduling properties,whats the default (sequential)
What are the restrictions of union transformation?
What is meant by query override?
Why do you use Mapping Parameter and mapping variable?
Explain load alternative records / rows into multiple targets - informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain the informatica workflow?
How many transformations can be used in mapplets.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can you please explain me pre session and post session options?
In which transformation you cannot drag ports into it?
How to elaborate tracing level?
How you can differentiate between connected lookup and unconnected lookup?
What is the benefit of partitioning a session?
How do you take back up of repository?
