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
- 5904 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
Is it possible to revert a global repository to local one and why?
Explain the informatica workflow?
What are the types of lookup transformation?
How can we use mapping variables in informatica? Where do we use them?
What is domain in terms of informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the databases that informatica can connect to windows?
What are the main issues while working with flat files as source and as targets ?
What is meant by pre and post session shell command?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is session task and command task?
What is a repository manager?
How can a transformation be made reusable?
Define enterprise data warehousing?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
