Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



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

Answer / jaimeen shah

if you talk about in Informatica then in mapping use
Source Definition --> Source Qualifier (Default T/R) -->
Modified the SQ query to load the data that you have
required.
select empid, ename, sum(sal) as totalsal from test1
Group by years, ename, empid
Order by ename, empid
and connect the SQ ports to Target definition.
It gives you the result which you require.

Is This Answer Correct ?    5 Yes 2 No

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

Answer / kumarvijay

If your source is file then use agrregator with aggregation
on year,emp_id have port with sum(sal).

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is an expression transformation in informatica?

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 is mapping performence?

2 Answers   Cap Gemini,


What do think which one is the better joiner or look up?

0 Answers  


What is resilience time?

0 Answers  






How can we use batches?

0 Answers  


Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,


a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,






Categories