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 / kumarvijay
If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).
|Is This Answer Correct ?||2 Yes||1 No|
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the different types of transformation available in informatica.
What is difference between a gateway node and worker node?
What are the different components of powercenter?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? email@example.com
What is the need for an etl tool?
What are the features of complex mapping?
Please let me know how to make Data masking in informatica..
What is the commit type if you have a transaction control transformation in the mapping?
Enlist the differences between database and data warehouse.
How to update source definition?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.