Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Sep 2007 @ 17:34:01 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Teradata and ETL
 
From:   Mogilevsky, Boris

Hi Kamin, I have been in numerous projects utilizing both approaches and here is my opinion.

When you limit yourself just to basic TD utilities your production support costs are relatively low considering that you just need to have basic TD skills, though you do not possess great capabilities of ETL tools. But in the last case you are increasing the complexity of your system and you need to have additional skill set on a personnel side, additional costs associated with ETL server support, etc. One of the projects I was in we have looked into ETL tools available and finally a decision has been made to perform all sophisticated flat file manipulations in COBOL before passing massaged data to TD utilities. It worked very good, this was a channel attached environment and we preferred not to send files back and force from ETL server to TD server considering it would not be as reliable as connection between MF and TD server. So, like people like to say, 'it all depends' ! Look at your current configuration and how much money you want to spend now and in the future. Production support is very important as TD warehouses are not cheap.


Boris Mogilevsky
TERADATA Professional Services



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023