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

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal.
Is there any othere transformation than the aggrator? if
yes how?

Question Posted / ronni2216

Answers were Sorted based on User's Feedback



In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation tha..

Answer / rampriya

I think, we can use the source qualifier (active
transformation)- query override

select sum(sal) from emp where dept=10

Is This Answer Correct ?    10 Yes 3 No

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation tha..

Answer / sahil

We can use a query,

Select dep_id, sum(salary) from emp group by dep_id;

Here I am using group by because we might have other dep as well.

Is This Answer Correct ?    0 Yes 0 No

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation tha..

Answer / arun kumar

Hey Friend,
First try to understand the query first.Here we need to calculate the sum salary of 5 members from deptno 10 with using Aggregation Transformation in informatica.

Yes, we can calculate group of records with our using aggregator by taking 2 sorter transformation and 2 expression transformations and 1 filter transformation.

I have done this with using 5 transformations and it worked.

Is This Answer Correct ?    0 Yes 1 No

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation tha..

Answer / eswar

No, In Informatica, you dont have any other transformation
than Aggregator. Aggregator is used for calculatins such as
Avg, Sum which are performed on groups.

Is This Answer Correct ?    2 Yes 5 No

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation tha..

Answer / talluru.sankar naidu

we can use SQ transformation write the query we get ans


select sun(sal) from emp where deptno=10 and deptno=5;



I think its correct

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More Informatica Interview Questions

How to display First letter of Names in Caps?

7 Answers  

What are parallel querys and query hints?

1 Answers  

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  




Explain about cumulative Sum or moving sum?

0 Answers   Informatica,

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,

Kimball and Inmon methodologies?

2 Answers  

Could you explain what is enterprise data warehouse?

0 Answers  

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

What are the different threads in DTM process?

1 Answers  

For more Informatica Interview Questions Click Here
Categories