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
- 4 Answers
- 9766 Views
- Magna Infotech, I also Faced
- E-Mail Answers
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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain how many types of dimensions are available in informatica?
What is status code in informatica?
Under which circumstances, informatica server creates reject files?
What is event and what are the tasks related to it?
What is a surrogate key?
Differentiate between joiner and lookup transformation?
How can we improve session performance in aggregator transformation?
how we can load rejected record's at run time?(not through bad files)
Explain the etl program with few examples.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain direct and indirect flat file loading (source file type) - informatica
what is the complex transformation you used in informatica
How can you differentiate between powercenter and power map?
What all are steps in up gradation of Informatica server?
