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

WHat all joins are there in Source Qualifier?

1 Answers  

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,

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

1 Answers  

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

Can you create a flatfile target

3 Answers   ABC,

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

What does reusable transformation mean?

1 Answers  

SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

How many numbers of sessions can one group in batches?

1 Answers  

what is the gap analysis?

1 Answers  

How to eliminate duplicate records in informatica mapping? Explain with an example....

1 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories