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
- 4859 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
Informatica settings are available in which file?
my source is junk data how will u remove that junk data by using unix please any one replay me
Name the different lookup cache(s)?
what is Active lock explain
What are the popular informatica products?
Explain pushdown optimization and types in informatica
Explain Dataware house architecture .how data flow from intial to end?
Why is sorter an active transformation?
Where do we use mapping variables in informatica?
Different circumstance which drives informatica server to expel records?
How does a rank transform differ from aggregator transform functions max and min?
can u give example for factless fact table
What are the steps involved in the migration from older version to newer version of Informatica Server?
EXL informatica Questions
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
