Data Warehousing Community Forum
February 08, 2012, 10:54:49 pm

Pages: [1]   Go Down
  Print  
Author Topic: Aggregator Vs Expression  (Read 1461 times)
unknown
DW Apprentice
**

Reputation: +8/-0
Offline Offline

Posts: 44



View Profile
« on: September 09, 2007, 03:54:06 pm »

We can do Expression related tasks by using Expression Transformation.
Then what is the essence of using an Aggregator?

Differentiate...?
Logged

Thanks
Unknown Smiley
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: September 12, 2007, 10:59:14 am »

Each specific transformations have their own advantages (mean to say actions) -

In the same way, An Aggregator transformation allows to perform aggregate calculations, such as averages and sums.

The Aggregator transformation is unlike the Expression transformation, where we can use the Aggregator transformation to perform calculations on "groups" and the Expression transformation permits us to perform calculations on a "row-by-row" basis only.
Logged

Pages: [1]   Go Up
  Print  
 
Jump to: