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

How do you convert single row from source into three rows into target?

0 Answers  


WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,


what is the size of u r project? and what is the size of source file?

1 Answers   HP,


Differentiate between sessions and batches?

0 Answers  


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,






how to we create datamart?

2 Answers   HSBC,


What is the use of incremental aggregation?

2 Answers  


What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,


what are the types of Data warehousing ?

1 Answers  


What is flashback table ? Advance thanks

0 Answers   Puma,


How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


what is confirmed dimension?

6 Answers  


Categories