Data Warehousing Community Forum
February 08, 2012, 10:52:15 pm

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Aggregator Transformation ?  (Read 3035 times)
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« on: July 10, 2007, 11:56:22 am »
What is an Aggregator Transformation ?
How this differs from Expression Transformation?

List out the various typres of aggregations that can be done through the Aggregator transformation?
Logged
If most people said what’s on their minds, they’d be speechless.
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: July 10, 2007, 02:16:18 pm »
Definition - A transformation which allows to perform aggregate calculations such as averages and Sums.

Difference between Aggregator and Expression -

The Aggregator transformation is used to perform calculations on groups unlike in Expression Transformation it is not possible.

Various types of aggregations are as follows -
  • SUM
  • AVG
  • COUNT
  • MAX
  • MIN
  • FIRST
  • LAST
  • MEDIAN
  • PERCENTILE
  • STDDEV
  • VARIANCE
Logged
Sipra
Founder

www.dwforum.net
gvc123
DW Fresher
*

Reputation: +1/-0
Offline Offline

Posts: 1


View Profile
« Reply #2 on: October 03, 2007, 01:42:33 pm »
Aggregator Transformation we can apply on group wise calculations where as the
SUM
AVG
COUNT
MAX
MIN
FIRST
LAST
MEDIAN
PERCENTILE
STDDEV
VARIANCE

where as expression we can do the expression on the single row wise calculations.

aggregator is an active transformation where as expression is the passive transformation.
Logged
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: