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 / vikneswaran
use agg trans group by empid and year then use sum(sal)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the procedure for creating independent data marts from informatica 7.1?
Explain Dataware house architecture .how data flow from intial to end?
How do you promote a non-reusable transformation to reusable transformation?
What is a difference between complete, stop and abort?
How to generate or load values in to the target table based on a column value using informatica etl tool.
my source is junk data how will u remove that junk data by using unix please any one replay me
how we can load rejected record's at run time?(not through bad files)
What is domain in terms of informatica?
Explain the code page compatibility?
What are the new features of informatica 9.x developer?
What is meant by a domain?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to do the error handling of if ur source is flatfiles?
What are the new features of informatica 9.x in developer level?