Answer / rampriya

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

select sum(sal) from emp where dept=10

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.

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.

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.

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

How can we use mapping variables in informatica?

0 Answers  

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

What are the mapings that we use for slowly changing dimension table?

2 Answers  

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

0 Answers   Patni,

How to retrieve last two days updated records?

4 Answers  

In Which scenario did u used Incremental loading?

2 Answers  

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

What is the difference between view and materialised view?

6 Answers