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
- 2 Answers
- 5682 Views
- I also Faced
- E-Mail Answers
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
what is song in infrmatica...?
I have a flat file, want to reverse the contents of the flat file
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Enlist few areas or real-time situations where informatica is required.
Explain the types of transformations?
What do you mean by channel change?
What is status code in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Can we create a Integration service without a Repository service and vice versa?
Why do we need informatica?
How to open an older version of an object in the workspace?
Explain the etl program with few examples.
What is enterprise data warehousing?
Explain the aggregator transformation?
