Use of Aggregator Transformation

In source qualifier transformation we can writer customer query. That means we can do aggregator calculations also. So what is the need of Aggregator Transformation?

Questions by sekhar.ganta   answers by sekhar.ganta

Showing Answers 1 - 2 of 2 Answers

ravi_se2000

  • Jan 16th, 2008
 

Sourcequalifier transformation filters rows when it reads the souce data from the PowerCenter Server if you give any filter condition, but Aggregator transformation is used for multiple filter conditions and even it will have default condition so you can send different conditions of data into different target tables with single aggregator rather than using may filter transformations
hope it is ok for you, if not correct me

 

  Was this answer useful?  Yes

Mamta11

  • Jul 26th, 2008
 

What if you want to aggregate the data down the pipeline (after manipulating the source data). This is where you require aggregate transformation.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions