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
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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How might one distinguish in the case of mapping is right or not without associating session?
What is a dimensional model?
How do you load only null records into target?
How to join three sources using joiner? Explain though mapping flow.
Why is sorter an active transformation?
Explain the mapping variable usage example in informatica
What is the benefit of partitioning a session?
draw informatica architecture 8.6 ?
Enterprise data warehouse your projects phase by phase explain?
How many numbers of sessions can one group in batches?
lookup transformation with screenshots
Difference between Target-based loading and constraint-based loading?
update strategy transformation in informatica
What is mapping debugger?