Where should the ETL be ?

Manoj Panda at 18h35
06
Feb
2011
Where should the ETL be ?

As I understand in organisational IT architecture there are 3 tiers.

1st tier(Data storage layer) : All the databases .
2nd tier(Business Tier ): All the middleware applications that include ETLs, messaging middleware , object oriented middleware etc
3rd tier(Client layer/Presentation layer) : Front end applications .

My question is why should ETL remain in the second tier instead of the first tier .

About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Forums from same category
See also
more_less
Informations

4 Replies For the topic :
"Where should the ETL be ?"

This topic has been viewed 1368 times.

Last message :
06/02/2011 at 18h35 by "Manoj Panda"