ETL Server Sizing

sjain Mon Sep 07, 2009 4:04 am

Hi,

Could help me to suggest what should be the possible considerations for sizing an ETL Server?

Like platform( UNIX, Linux, Windows), Volume of data(in GBs), type of source(relational, application, files), type of transformation/transforms(type of operartion such as SCD) ,Batch - window( Daily, weekly, monthly) sampling rate, commit size

How it affect the sizing (directly or indirectly)
Or is it depend upon the tool you are using like SAP BO Data Services, Informatica, Datastage

Any help!!