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
- 4905 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 |
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
what is sql override?what is the use of it?
What is the commit type if you have a transaction control transformation in the mapping?
what is meant by data driven.. in which scenario we use that..?
What can we do to improve the performance of informatica aggregator transformation?
what r the values tht r passed between informatics server and stored procedure?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
WHAT IS FACT TABLES?
tell me the rules and responsblites in our project(my project is development)
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What are the types of caches in lookup?
How does the session recovery work.
Teradata 
