Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

3938


What are the different types of transformation available in informatica.

208


What is difference between a gateway node and worker node?

218


What are the different components of powercenter?

199


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1145






What is informatica?

199


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1224


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1049


What is the need for an etl tool?

217


What are the features of complex mapping?

199


Please let me know how to make Data masking in informatica..

865


What is the commit type if you have a transaction control transformation in the mapping?

257


Enlist the differences between database and data warehouse.

189


How to update source definition?

218


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.

196