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

How the Informatica Server reads perameter file?

1 Answers  

Insert else update option in which situation we will use

4 Answers   HCL,

How to update records in Target, without using Update Strategy?

3 Answers  

h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,

What is pmcmd command?

0 Answers  




Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

4 Answers  

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

what is constraint based load order

2 Answers   Cap Gemini,

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

For more Informatica Interview Questions Click Here
Categories