Data Warehousing Community Forum
February 08, 2012, 10:54:49 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
ETL Tools
>
Informatica
>
Aggregator Vs Expression
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Aggregator Vs Expression (Read 1461 times)
unknown
DW Apprentice
Reputation: +8/-0
Offline
Posts: 44
Aggregator Vs Expression
«
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
Sipra
Founder
Reputation: +59/-0
Offline
Posts: 323
Am the King...
Re: Aggregator Vs Expression
«
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
Sipra
Founder
www.dwforum.net
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA