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
- 5976 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kumarvijay
If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).
| Is This Answer Correct ? | 2 Yes | 1 No |
why union transformation is active transformation?
without update strategy how to insert &update?
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
Please let me know how to make encryption and decryption with example?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
What are the components of workflow manager?
COM components can be used in Informatica
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
How to load a Dimension ? and how to load a fact table?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
what is a transforamation?
What is a poling?
Teradata 
