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

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

Types of error logs in Informatica?

2 Answers  

How the informatica server increases the session performance through partitioning the source?

1 Answers  

What is a mapplet/worklet in informatica?

0 Answers  

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,




How can u stop a batch?

2 Answers  

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

What is the procedure to load the fact table.Give in detail?

1 Answers  

hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

For more Informatica Interview Questions Click Here
Categories