when we dont use aggregator in mapping ?

Answers were Sorted based on User's Feedback



when we dont use aggregator in mapping ?..

Answer / suraj kedia

Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....

So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.

Is This Answer Correct ?    13 Yes 0 No

when we dont use aggregator in mapping ?..

Answer / vikram

when thre are no group by or any other calculations required

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Informatica Interview Questions

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


how did u understand business requirement?

2 Answers   TCS,


How to load a relational source into file taget?

2 Answers  






Explain informatica architecture - version 8 / 9

0 Answers   Informatica,


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


What are the different types of olap? Give an example?

0 Answers  


What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  


What is the use of source qualifier?

0 Answers  


What is hash partition?

1 Answers  


wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,


Categories