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
- 4 Answers
- 11028 Views
- Magna Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sachin
use an aggregrator where you need to check the group by
port as emp id, ename and year.
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / xyz
select empid, year, sum(sal) as Totalsalary
From employees
group by empid, year;
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / vikneswaran
use agg trans group by empid and year then use sum(sal)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ankit kansal
Using SQL->
select empid,ename,year,sum(sal) Total_Sal from table_name
group by empid,ename,year;
Using Informatica->
SRC->SQ->Agg(sum(sal)[group by empid,ename,year])->TGT
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
Can anyone tell me the new features in Informatica 9 Version?
What is the scenario which compels informatica server to reject files?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
What are 2 modes of data movement in Informatica Server?
What are the unsupported repository objects for a mapplet?
What is the procedure to load the fact table.Give in detail?
what is the difference between repository & Intergration service
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Teradata 
