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
- 10746 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
Please let me know how to make Data masking in informatica..
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is expression transformation?
What is the way to execute pl/sql script using informatica mapping?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the pipeline partition with real time example?
what is informatica metadata?
Explian the Process of deployment groups in informatica
explain one complex mapping with logic? sales project?
Explain lookup transformation is active in informatica
What is union transformation?
How do you convert single row from source into three rows into target?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
