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

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,




I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,

which quality process u can approach in ur project

1 Answers   CTS,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

How to generate the HTML output using Informatica.

3 Answers   Wipro,

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

For more Informatica Interview Questions Click Here
Categories