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
- 10759 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 |
What is an aggregator transformation?
i have 2 session s1 execute s2 load first session fail what is the reason?
What are the tasks that source qualifier performs?
How would you copy the content of one repository to another repository?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
can we generate reports in informatica ? How?
What is the difference between stop and abort in informatica
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
what are the row and column separations in Flat Files
Teradata 
