Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5919 Views
- I also Faced
- E-Mail Answers
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
How to use pmcmd utility command?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is data movement mode in Informatica and difference between them?
What is the difference between source qualifier transformations source filter to filter transformation?
What is blocking transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Define enterprise data warehousing?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is target load order?
Is there any way to read the ms excel datas directly into informatica?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
In how many ways we can create ports?
How many ways a relational source definition can be updated and what are they?
Partition, what happens if the specified key range is shorter and longer
