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 / sachin
use an aggregrator where you need to check the group by
port as emp id, ename and year.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is a code page?
What are the restrictions of union transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is meant by lookup transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the meaning of decode in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
How to convert multiple rows to single row (multiple columns) in informatica
Explain the different dimensions.
wat are deployement groups in informatica, how it will be used for developers
Define mapplet?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How do you migrate data from one environment to another?
Difference between Data and Index Caches?