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
- 4 Answers
- 10882 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answer Posted / xyz
select empid, year, sum(sal) as Totalsalary
From employees
group by empid, year;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
COM components can be used in Informatica
Which version configuration tool used in ur project?
How can we create index after completion of load process?
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?
How many input parameters can exist in an unconnected lookup?
What is the need of etl tools?
Explain how many types of dimensions are available in informatica?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the various types of transformation?
Enlist few areas or real-time situations where informatica is required.
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
In development project what is the process to follow for an etl developer from day1
State the limitations where we cannot use joiner in the mapping pipeline?
Informatica Checkpoints
