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
- 9759 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 |
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
what is degenerated dimension?
4 yrs etl devloper roles and responsibilities?any body give solutions
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
how to connect two or more table with single source qualifier?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
How many dimensions are there in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Teradata 
