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
- 10902 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 $$$$?
What is status code in informatica?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are the issues you have faced in your project? How did you overcome those issues?
Can you start a batches with in a batch?
can you please explain me pre session and post session options?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
In target table how to display the system time
What is the default source option for update stratgey transformation?
Briefly define reusable transformation?
Explain the shared cache and re-cache?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
Teradata 
