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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
In informatics server which files are created during the session rums?
list out all the transformations which use cache?
Scheduling properties,whats the default (sequential)
What is source qualifier transformation in informatica?
Design time, run time. If you don't create parameter what will happen
Differentiate between router and filter transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Difference between Target-based loading and constraint-based loading?
Explain joiner transformation in informatica
Why update strategy and union transformations are active? Explain with examples.
Design a mapping to load a target table with the following values from the above source?
How can we use batches?
What is blocking transformation?
What is mapping debugger?