Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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


Please Help Members By Posting Answers For Below Questions

my source is junk data how will u remove that junk data by using unix please any one replay me

2834


How to create the source and target database connections in server manager?

239


What is transformation?

187


How to go to the older version for a mapping?

212


Different qualification between a related rotate toward the sky and isolates look upward?

198






Define filter transformation?

230


Partition, what happens if the specified key range is shorter and longer

1599


what is the hint? how to use it to reduce the query processing in program?

4937


What is the reusable transformation?

200


WHat all joins are there in Source Qualifier?

187


Why union transformation is an active transformation?

249


Can we use the mapping parameters or variables created in one mapping into another mapping?

283


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?

210


What is domain and gateway node?

220


what is mean by complex business rule ?

1227