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
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|
my source is junk data how will u remove that junk data by using unix please any one replay me
How to create the source and target database connections in server manager?
What is transformation?
How to go to the older version for a mapping?
Different qualification between a related rotate toward the sky and isolates look upward?
Define filter transformation?
Partition, what happens if the specified key range is shorter and longer
what is the hint? how to use it to reduce the query processing in program?
What is the reusable transformation?
WHat all joins are there in Source Qualifier?
Why union transformation is an active transformation?
Can we use the mapping parameters or variables created in one mapping into another mapping?
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?
What is domain and gateway node?
what is mean by complex business rule ?