1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / shankarid

Answers were Sorted based on User's Feedback



i have a table like empid ename year month sal 1 x ..

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

i have a table like empid ename year month sal 1 x ..

Answer / xyz

select empid, year, sum(sal) as Totalsalary
From employees
group by empid, year;

Is This Answer Correct ?    6 Yes 0 No

i have a table like empid ename year month sal 1 x ..

Answer / vikneswaran

use agg trans group by empid and year then use sum(sal)

Is This Answer Correct ?    3 Yes 1 No

i have a table like empid ename year month sal 1 x ..

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

Post New Answer

More Informatica Interview Questions

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

What is the difference between router and filter?

0 Answers  

why we use materialized view over view?

1 Answers   Zensar,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,




where is the reject loader .

1 Answers  

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

What is a joiner transformation and why it is an active one?

0 Answers  

What is dimensional table?

0 Answers  

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

What are the different components of powercenter?

0 Answers  

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories