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
- 4893 Views
- I also Faced
- E-Mail Answers
Answer Posted / jaimeen shah
if you talk about in Informatica then in mapping use
Source Definition --> Source Qualifier (Default T/R) -->
Modified the SQ query to load the data that you have
required.
select empid, ename, sum(sal) as totalsal from test1
Group by years, ename, empid
Order by ename, empid
and connect the SQ ports to Target definition.
It gives you the result which you require.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
list out all the transformations which use cache?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Enlist few areas or real-time situations where informatica is required.
tell me the rules and responsblites in our project(my project is development)
Different circumstance which drives informatica server to expel records?
What are the data movement modes in informatica?
What are roles and groups and benefits of using them?
What is decode in informatica?
What is a connected transformation?
What differs when we choose the sorted input for aggregator transformation?
What are the new features of Power Center 5.0?
Differentiate between a database and data warehouse?
what is unit testing?tell me proceedure
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define update strategy?
