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
- 2 Answers
- 5825 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 |
How you know when to use a static cache and dynamic cache in lookup transformation?
what is difference between dimention table and fact table?
what are objects in data warehouse?
What is rank index in rank transformation?
Does an informatica transformation support only aggregate expressions?
What are data-driven sessions?
How to enter same record twice in the target table,explain?
What is meant by lookup transformation?
Difference between task flow and linear task flow
Is there any model difference between ODS and DWH
how to load only the first and last record of a flat file into the target?
What is Factless fact table ???
12 Answers Satyam, Tech Mahindra,
Teradata 
